We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Build a Zap that appends a row to a Google Sheet every time a new customer is created in CleanOps.
This Zap adds a row to a Google Sheet every time a new customer is created in CleanOps — handy for building a mailing list, a backup contact list, or a feed into another tool.
Before you start: connect CleanOps to Zapier first (see connect CleanOps to Zapier), have a Google account, and create a Google Sheet with a header row (for example Name, Email, Phone) for the rows to land in.
You need CleanOps connected to Zapier (connect CleanOps to Zapier), a Google account, and a Google Sheet with a header row — the column names (e.g. Name, Email, Phone) become the fields you map to.
In Zapier, create a new Zap. For the trigger, choose CleanOps as the app and New Customer as the event, pick your connected CleanOps account, and select Continue.
A new Zap with the CleanOps New Customer trigger.
Select Test trigger. Zapier pulls your most recent customers from CleanOps — pick one and select Continue with selected record.
Zapier finds recent customers to test with.
For the action step, choose Google Sheets as the app.
Choosing Google Sheets as the action app.
Pick the Create Spreadsheet Row action event, then select Sign in to connect your Google account. When Google asks, grant access to Google Sheets and Drive (tick the permission boxes) so Zapier can add rows — otherwise the connection won’t work. Connecting an app works like connecting CleanOps.
The Create Spreadsheet Row action, ready to connect Google.
Choose your Spreadsheet and its Worksheet (for example Sheet1). Once you pick the worksheet, Zapier reads the header row and shows one field per column — here Name, Email, and Phone.
Selecting the spreadsheet and worksheet.
For each column, use Insert Data (the +) to drop in the matching CleanOps customer field — map Full Name into Name, Email into Email, and so on. Available fields include Full Name, Company Name, Email, City, State, Type, and recent-invoice details. Leave any column blank to skip it, then select Continue.
Mapping CleanOps customer fields to the sheet columns.
Select Test step. Zapier adds a real row to your sheet using the sample customer — you’ll see A Row(s) was sent to Google Sheets.
The test adds a real row to the sheet.
Select Publish. Zapier confirms Your Zap is on — from now on, every new CleanOps customer adds a row automatically.
Publishing turns the Zap on.
Each time a customer is created in CleanOps, a new row appears in your Google Sheet with the fields you mapped. Open the sheet any time to see the growing list.
The new customer row added to the Google Sheet.
Need more help? If you can't find what you're looking for in our documentation, create a support ticket and our team will assist you.