Google Sheets integration
Connect Google Sheets to 200+ apps
The Google Sheets integration on Connectify turns a spreadsheet into a log, a queue or a control panel. Orders, payments and leads become rows as they happen; a new or changed row can start a workflow of its own; and the Loop step works through every row to create records elsewhere.
What you can do
3 triggers and 15 actions, straight from the app
Each item is a real step in the Connectify builder. Fields are filled by typing @ to insert data from the trigger or an earlier step.
- Row addedConnectify checks the sheet on your interval and starts the workflow for each new row. The first check records the rows already there so old data does not flood in.
- Row updatedStarts the workflow when an existing row changes. New rows do not fire this one.
- Row added or updatedStarts for both, with a change type on each record so a Filter can branch.
Rows
- Append rowAdds a row at the bottom, matching values to the header columns in row 1.
- Update rowFinds the first row where a column matches a value and overwrites it.
- Delete rowFinds the first matching row and removes it; rows below shift up.
- List rowsReads the rows of a tab, optionally a range, as values, raw values or formulas.
- Get rowReads one row by number.
- Clear sheetClears values in a tab or range and keeps the formatting.
Sheets (tabs)
- Create sheetAdds a tab with a unique title.
- Update sheetRenames a tab or hides and shows it.
- Delete sheetRemoves a tab and its data.
- List sheetsLists the tabs in a spreadsheet with their IDs.
- Get sheetReads a tab’s title, size and hidden state.
Spreadsheets
- Create spreadsheetCreates an empty spreadsheet and returns its ID and link.
- List spreadsheetsLists the spreadsheets the connected account can reach.
- Get spreadsheetReads a spreadsheet’s title, properties and tabs.
- Get userReturns the connected Google account, to check the connection.
Popular workflows
What people build with Google Sheets
Start from one of these in the app, then tell Copilot what is different.
Every paid order becomes a rowOrder number, customer, total and items are appended to an orders sheet the moment payment is captured.Use this workflow
Stripe checkout logged with the productEach completed checkout adds the customer and product to a sheet for the finance team.Use this workflow
Sheet rows into a Notion databaseContacts added to a sheet appear in Notion, with the Loop step working through every new row.Use this workflowBulk-create Shopify customersA sheet of customers is turned into store customers, one per row.Use this workflow
Lead sheet, scored and replied toA new row is scored by an AI step, a HubSpot contact is created and a reply goes out from Gmail.Use this workflow
Daily summary to SlackEvery weekday at 08:00 the sheet is read, totals are summarised and posted to #sales.Use this workflowHow to connect
Set up Google Sheets in a few minutes
No code and nothing to install. Connect Google Sheets once and use it in any workflow.
- Add a Google Sheets stepOpen a workflow in the builder, add a step and choose Google Sheets.
- Sign in to Google SheetsChoose "Continue with Connectify", sign in to Google Sheets and approve the access it asks for. You can also enter your own Google Sheets app credentials instead.
- Choose the action and map fieldsPick what the step should do, then fill each field. Type @ to insert data from the trigger or an earlier step.
- Test itPress Test to run the step once with real data and see what comes back.
- Switch the workflow onEvery run is recorded in run history with what each step received and returned.
Permissions and data
What Connectify asks Google Sheets for, and why
Only the access the actions above need. You approve it on the provider's own page when you connect.
- Connectify reads and writes only the spreadsheets and tabs your workflow steps name.
- Your Google token is encrypted before it is stored and decrypted only while a Sheets step runs.
- Connectify’s use of Google user data follows the Google API Services User Data Policy, including the Limited Use requirements; see the privacy policy.
- Disconnect at any time from the account settings in Connectify or from your Google account permissions page.
Full details in the privacy policy.
- spreadsheets
- Read and write the spreadsheets your steps name.
- drive.file
- Create new spreadsheets and open the ones you pick.
- userinfo.email
- Show which Google account is connected.
FAQ
Google Sheets questions
How often is the sheet checked?
At the interval you set on the trigger. Each check remembers what it has seen, so a row is never run twice.
Does the first check run for every existing row?
No. The first check records the rows already in the sheet; only rows added after that start the workflow.
What if my sheet has no header row?
Rows are matched to the header in row 1, so give each column a name there. Values are then available by that name when you type @.
Can I use my own Google app?
Yes. When you connect, choose to enter your own Google app credentials instead of "Continue with Connectify".
Stuck on a Google Sheets step? Write to support@connectify.co or report an issue. Include the workflow name and the run from Logs.
Connect Google Sheets in minutes.
Free plan, no card, 200+ apps. Describe the workflow to Copilot or build it by hand.