AI WORLD HQ
How to Automate Business Tasks with Zapier — Step by Step
The average small business owner spends two to three hours every week copying information from emails into spreadsheets — order details, inquiry forms, sign-up confirmations. It is the kind of work that adds up without adding value.
There is a simpler way. A tool called Zapier acts as a bridge between the apps your business already uses. When something happens in one app (an email arrives), Zapier automatically does something in another app (adds a row to your spreadsheet). This is a simple form of what the industry calls an AI agent (a smart software program that performs tasks across your apps automatically, without you needing to do each step manually).
Below is a step-by-step walkthrough for building your first automation. You will need a free Zapier account and a Google account for Sheets.
Step 1 — Sign up for Zapier and start a new Zap
Open your browser and go to zapier.com. Click the Sign up button in the top right corner. You can create an account with your email address or sign in with Google — the Google option is faster if you already use Gmail and Google Sheets.
Once you are logged in, you will land on your dashboard. Look for the large orange button on the left side that says Create Zap. Click it.
💬 Copy this: Visit zapier.com → click Sign up (top right) → sign in with Google for quickest setup.
You'll know it worked when you see the Zap editor screen, which has a section labeled Trigger on the left and an Action section on the right.
Step 2 — Set your trigger app (the thing that starts the automation)
In the Zap editor, click the Trigger section. A search box will appear labeled App event. Type Email and select Email by Zapier from the results. This is Zapier's built-in email tool — it gives your Zap its own inbox address.
After selecting Email, a second field will appear labeled Event. Click it and choose New Email. This tells Zapier: "When a new email arrives in your Zapier inbox, run this automation."
You will now see a field for your Zapier Inbox Email Address. Copy this address — you will use it in a moment. At the top of the Zap editor, give your Zap a name by clicking the Untitled Zap text and typing something like "Email to Sheet".
💬 Copy this: Trigger App: Email by Zapier → Event: New Email → copy your Zapier inbox email address.
You'll know it worked when you see a field displaying your unique inbox address in the format [email protected].
Step 3 — Forward an email to your Zapier inbox
Now you need to test that Zapier can actually see your emails. Open your regular email account (Gmail, Outlook, or whatever you use for business). Find any email — it does not matter which one.
Look for the Forward option in your email toolbar. Paste your Zapier inbox address into the forward field and send it.
Go back to the Zapier tab. In the Zap editor, click the Test trigger button near the bottom of the trigger section. Zapier will reach out and pull in the email you just forwarded. You should see the email subject, sender, and body appear in a preview box.
💬 Copy this: In your email → Forward → paste [email protected] → send → click Test trigger in Zapier.
You'll know it worked when the preview on screen shows the exact email you forwarded — subject line, sender address, and body text all matching.
Step 4 — Connect Google Sheets as your action app
Now click the Action section on the right side of the Zap editor. A search box will appear labeled App. Type Google Sheets and select it from the results.
A second field will appear labeled Event. Click it and choose Create Spreadsheet Row. This tells Zapier: "When a new email arrives, add a new row to this spreadsheet."
Zapier will ask you to connect your Google account if you have not done so already. Click Sign in to Google Sheets, grant the permissions, and return to the Zap editor.
Now you need to tell Zapier which spreadsheet and which sheet tab to use. In the Spreadsheet field, select your spreadsheet from the dropdown. In the Worksheet field, select the specific tab inside that spreadsheet (for example, "Sheet1").
Below that you will see a list of your spreadsheet's column headers. Click each one and map it to the corresponding part of the email — drag the Subject field into one column, From (sender) into another, and Body Plain into a third. This tells Zapier exactly where to put each piece of information.
💬 Copy this: Action App: Google Sheets → Event: Create Spreadsheet Row → connect Google account → select your spreadsheet and worksheet tab → map email fields to columns.
You'll know it worked when the column mapping screen shows a line from each email field (Subject, From, Body Plain) into your spreadsheet columns, with the dropdowns all showing green ticks.
Step 5 — Test your automation end to end
With the mapping done, click the Test button at the bottom of the Action section. Zapier will run a live test — it will send the email you forwarded earlier straight into a new row in your Google Sheet.
Open your Google Sheet and check. You should see a brand new row at the top (or bottom, depending on your sheet settings) with the email subject in one column, the sender's address in another, and the body text in a third.
If the data looks correct, click the orange Publish button in the top right corner of the Zap editor. Your Zap is now live.
💬 Copy this: Click Test → open Google Sheet → verify row was created → click Publish (top right).
You'll know it worked when the Publish button turns gray and shows a green tick, and when a new row appears in your spreadsheet moments after you forward an email.
Step 6 — Use your automation in the real world
Now that your Zap is live, you can start using it properly. Instead of manually copying data, you simply forward relevant emails to your Zapier inbox address whenever you receive an order, a sign-up, or an inquiry.
Create a rule in your email app to automatically forward certain emails. In Gmail, go to Settings → See all settings → Filters → Create a new filter. Set your conditions (for example, emails with "order" in the subject) and check the box Forward it to — paste your Zapier inbox address there.
This means every order email your business receives will automatically flow into your spreadsheet without you touching it.
💬 Copy this: Gmail → Settings → See all settings → Filters → Create a new filter → condition: subject contains "order" → Forward it to: [email protected] → Create filter.
You'll know it worked when emails matching your filter automatically appear as new rows in your spreadsheet within a minute or two of arriving in your inbox.
Common mistakes
Mistake 1: Sending test emails to the wrong address It is easy to forget which inbox belongs to which Zap. If your spreadsheet is not updating, check that you are forwarding to the correct Zapier inbox address — each Zap has its own unique address. Find it in the Trigger section of your Zap editor.
Mistake 2: Mismatched column headers If Zapier cannot find a column in your spreadsheet, it will skip that field. Make sure your spreadsheet column headers match exactly what you typed in the mapping screen — a space or a missing word will break the connection. Double-check spelling and capitalisation.
Mistake 3: Leaving the Zap unpublished Many users complete the setup and test it successfully, but forget to click Publish. An un-published Zap only runs during testing and stops as soon as you close the editor. Always click Publish when you are ready to use the automation for real.