🚀 How It Helps You #
When you’re running a busy shop or selling at events, it’s easy to lose track of purchases if you’re updating spreadsheets by hand. Workload gives you a simple way to connect your accounts and track Zettle purchases automatically in Google Sheets, so every sale is recorded the moment it happens—no coding required.
It captures key details like product name, quantity, price, and customer name, even when multiple items are sold in a single order. A built-in AI Formatter step cleans up the purchase data from Zettle so it fits neatly into your sheet, column by column.
With everything logged in real time, you can avoid stock mistakes, speed up bookkeeping, and stay on top of your numbers—whether you’re syncing inventory or just trying to make tax season less painful.
🧩 Essentials & Connections #
Before you build, here’s what you’ll need:
🧾 Zettle account with active purchase activity
📊 Google Sheets account with a spreadsheet ready for logging sales
🚀 Workload account (free or paid) to create your automation
Workload makes connecting these tools seamless. Just sign in and grant access when prompted.
⚙️ How to Track Zettle Purchases Automatically #
Step 1: Create a new automation to track Zettle purchases automatically #
- Go to your Workload Dashboard and click Create Workflow
- Enter a name for your automation (ex: “Zettle to Google Sheets”)
Step 2: Set up your Zettle trigger #
- In Step 1, click the Trigger box, select the app: PayPal Zettle
- Pick New Purchase as the trigger event
- Move forward by pressing Continue
- If this is your first time connecting an account, click on Sign in to open begin the process to authorize your Zettle login
- In the pop-up window, enter your account email address in the Email field, then click Next
- Now, enter the account password
- Once linked, proceed with Continue
- Hit the Test Trigger button to pull in sample purchase data
- After the test runs successfully, select Continue
Step 3: Format the purchase data for Sheets #
- Click in to Step 2 of the workflow, then select the TOOLS menu and the app: AI Formatter by Workload
- Select the event Format Data, then click Continue
- Set the Input Data field to the
productsarray from your Zettle by PayPal trigger
- Next, write a prompt that will turn the array into an object (ex: Turn this array into an object) and then click Continue
- Run a Test Action to preview the formatted data and make sure the output separates product name, price, and quantity
- If everything looks right, move on by hitting Continue
Step 4: Add the Google Sheets integration #
- Add a Step 3 using the + icon below Step 2
- Choose Google Sheets as your app
- Select Create Spreadsheet Row as the action event, then click Continue
- Use the Sign in button to begin the process of linking your Google Sheets account to Workload
- Next, choose the Google account you want to use
- You will now see a message that Google hasn’t verified the app yet (sorry about that, we are working hard to get this removed), click on Advanced
- Now hit the Go to workload.co (unsafe) button
- You will now see a new message, click Continue
- You will now grant access to your Google Sheets account by clicking Continue
- Enter a name for your connection and click OK
- After your account has been linked, click Continue
- Pick your destination spreadsheet and worksheet from the dropdown menus
- Hit + Add to and begin to map the data you want in specified columns (Note: you may add as many of these boxes as you need)
- When you have finished mapping all the data you want to use, advance to the next screen by selecting Continue
Step 5: Test and launch your Track Zettle Purchases Automatically automation #
- Run a Test Action on the Google Sheets step to send a test row
- Once you receive a successful response, click Continue
- Open your spreadsheet to confirm the new row appears with accurate values
- Review all steps in the Workload editor and look for green indicators
- To finish, toggle the Activate switch in the top-right corner—your automation is now live!
🔓 Unlocked: Track Zettle Purchases Automatically in Google Sheets #
This automation unlocks a fast, accurate way to sync your in-person Zettle sales with Google Sheets—no more manual updates, missing data, or late-night spreadsheets. With every purchase logged instantly, your team stays aligned, your reports stay clean, and your inventory stays accurate.
🛠️ Customizing Your Automation #
This automation is flexible and easy to adapt. Here are a few simple ways to make it even more powerful for your workflow:
🔍 Filter by product or location
Include only specific products or limit entries to certain store locations by adding a filter step after your Zettle trigger.
🕓 Format price or date fields
Use the AI Formatter to adjust number formats, strip decimals, or convert timestamps before sending to Google Sheets.
📊 Add new columns for tracking
Expand your spreadsheet to include details like order ID, payment method, or tax. Then map those fields from Zettle accordingly.
🈺 Translate product names or tags
Reword product names, add custom tags, or translate values using a Formatter step—great for internal teams or multiple languages.
🔗 Connect with other tools
Send Slack alerts, update Airtable records, or trigger additional actions by branching this automation to other apps.
⚡ Power-Up: Make It Part of a Bigger Automation Workflow #
Once your Zettle purchases are flowing into Google Sheets, you can scale this automation to cover even more business processes:
📣 Send real-time Slack alerts
Notify your team instantly in Slack when a new sale comes in—great for operations, fulfillment, or team motivation.
📦 Update inventory in Airtable
Log product counts or sales data directly in Airtable to keep inventory, SKUs, or stock levels fully aligned.
📧 Send email receipts or alerts
Use Gmail or another mail app to confirm sales, notify admins, or thank customers automatically.
Workload makes all of this possible with drag-and-drop simplicity. One automation, many outcomes—no switching tabs or writing code.
🧠 Learn More from Workload #
Keep exploring automation and save even more time:
📺 Watch the full tutorial video
📚 Visit Workload University
🛠️ Browse setup guides in our Help Center
🔗 Explore more Zettle by PayPal automation tutorials
🔗 Explore more Google Sheets automation tutorials
