Google Sheets
+
Konnectify
Google Sheets Integration with Konnectify
Connect Google Sheets to Konnectify to create, edit, and collaborate on spreadsheet data automatically—sync rows, manage
worksheets, and react to new or updated spreadsheets.
Rows
Worksheets
Spreadsheets
4 Triggers
9 Actions
What is Google Sheets?
Google Sheets is a cloud-based spreadsheet tool for creating, editing, and collaborating on tabular data in real time.
By integrating Google Sheets with Konnectify, you can keep operational data in sync across tools—automatically add, update,
find, and upsert rows, manage worksheets, and respond when new spreadsheets are created or updated.
New to Google Sheets?
Create a spreadsheet in Google Drive and organize data with worksheets (tabs) and rows.
Explore Google Sheets
What you can automate
• Append new rows to a worksheet
• Update an existing row by row reference
• Upsert rows using a unique key column (avoid duplicates)
• Find one or multiple matching rows by a unique field
• Create and delete worksheets (tabs)
• Trigger workflows when spreadsheets are created or updated
API & authentication
OAuth 2.0 authorization
Konnectify connects to Google Sheets using OAuth 2.0. During connection setup, you’ll be redirected to Google to grant
permission. Konnectify stores tokens needed to run your workflows and does not store your Google password.
Permissions used
-
Read spreadsheet metadata from Drive (scope includes Drive read-only) to detect new/updated spreadsheets and select files.
- Create and update spreadsheet content (Sheets scope) for row and worksheet operations.
- Create/manage files created or opened by the app (Drive file scope) for spreadsheet creation and access.
Important: rate limits & polling intervals
Google APIs enforce quotas and rate limits, and polling triggers run on a schedule. If you experience delays or missed
events, consider reducing the number of polling workflows, narrowing monitored sheets, and using unique keys with Upsert to
prevent duplicates.
Official docs:
Google Sheets API
and
Google Drive API.
How to connect
Prerequisites
- A Google account with access to the target spreadsheet(s) in Google Drive
- Permission to authorize Google Sheets access (OAuth consent)
- (Optional) A spreadsheet with a header row if you plan to reference columns by header name
Add Google Sheets to a Workflow
- Create a new workflow in Konnectify.
- Select Google Sheets as your trigger app or action app.
Authorize via OAuth 2.0
- Click Connect.
- Sign in to Google and approve the requested permissions.
- Return to Konnectify to complete the connection.
Configure the Trigger or Action
- Select the spreadsheet and worksheet (tab) you want to work with.
- Map fields (columns) to your workflow data.
- For searches/upserts, choose a unique column (by letter or header name) to match records reliably.
Warning
Column references must match your sheet structure. If you rename headers, insert columns, or change data types,
revisit your mappings to avoid writing data into the wrong columns.
Test the Workflow
- Run a test to fetch sample data from the trigger (or send a test row for actions).
- Confirm that row/worksheet selections and mappings are correct.
Activate the Workflow
- Turn on the workflow.
- Monitor the first few runs to confirm expected behavior (especially for polling triggers).
Triggers
4
Google Sheets triggers in Konnectify use polling (scheduled checks) to detect changes, then trigger once per
new/updated item.
Rows
2 triggers
New Row
Polls a worksheet and triggers for each new row detected.
New Row With Trigger Column
Polls a worksheet and triggers for each new row detected.
Spreadsheets
2 triggers
New Spreadsheet
Triggers when a new spreadsheet is created in the user's Google Drive.
Updated Spreadsheet
Triggers when a spreadsheet is updated in the user's Google Drive.
Actions
9
Use actions to create spreadsheets/worksheets and manage worksheet rows (add, update, upsert, find, and delete).
Spreadsheets
1 actions
Create Spreadsheet
Creates a brand new, blank spreadsheet in the user's Google Drive.
Worksheets
2 actions
Create Worksheet
Creates a new worksheet (tab) within an existing spreadsheet.
Delete Worksheet
Deletes an entire worksheet (tab) from the specified spreadsheet.
Rows
6 actions
Add Row
Appends a new row of data to the bottom of a worksheet.
Update Row
Updates values in a specific, existing row.
Upsert Row
Updates a row if it exists, inserts a new one otherwise.
Find Row by Unique Field
Searches a worksheet for an exact match in the specified column (by letter or header name).
Find Multiple Row by Unique Field
Searches a worksheet for an exact match in the specified column (by letter or header name).
Delete Row
Deletes a specific row from a worksheet.
Popular automations
Examples of common Google Sheets workflows you can build with Konnectify using the available triggers and actions.
Sync new rows into a standardized worksheet
When a new row appears in an intake sheet, upsert it into a master sheet using a unique key (like Email or Ticket ID).
New Row
→
Upsert Row
Auto-create a worksheet for each new spreadsheet
When a new spreadsheet is created, automatically add a worksheet (tab) for standardized tracking.
New Spreadsheet
→
Create Worksheet
Update a row when a spreadsheet changes
When a spreadsheet is updated, find the relevant row in an audit sheet and update status fields (use a unique match field).
Updated Spreadsheet
→
Find Row by Unique Field
→
Update Row
Create a new spreadsheet for each new intake stream
When a new row is detected in a trigger sheet, create a new spreadsheet (for a project/client) and optionally add a worksheet for onboarding.
New Row With Trigger Column
→
Create Spreadsheet
→
Create Worksheet
FAQ
How does authentication work for Google Sheets in Konnectify?
Konnectify uses OAuth 2.0. You sign in to Google and grant access, and Konnectify receives tokens to run workflows on your
behalf. Your Google password is never stored in Konnectify.
Which Google plans are supported?
This integration works with Google accounts that can access Google Sheets and Google Drive APIs, including most Google
Workspace and consumer Google accounts. Some organizations restrict OAuth apps via admin policies—if authorization fails,
ask your Workspace admin to allow Konnectify.
Are Google Sheets triggers instant?
No. All available triggers are polling triggers, which means Konnectify checks for changes on a schedule.
The exact interval depends on your Konnectify plan and workload. Polling is reliable, but not real-time.
How do I prevent duplicates when writing to a sheet?
Use Upsert Row with a unique field (for example: Email, Order ID, Ticket ID). Upsert updates the matching
row if found; otherwise it inserts a new row—this is the recommended approach for idempotent workflows.
What happens if Google rate limits my workflow?
If the Google Sheets/Drive API returns quota or rate-limit errors, Konnectify may retry depending on the error type. To
reduce the likelihood of throttling, batch changes where possible (fewer writes), avoid excessive polling workflows, and
scope workflows to only the required spreadsheets/worksheets.
Can I connect multiple Google accounts?
Yes. You can create multiple Google Sheets connections in Konnectify (for example, one per Workspace or per team). Make sure
each workflow step selects the correct connection.
Should I reference columns by letter or by header name?
If your worksheet has stable headers, using header names is easier to maintain. If your sheet doesn’t have headers or you
want strict positional mapping, use column letters. Note that inserting/reordering columns can affect letter-based mapping.
Ready to automate your Google Sheets workflows?
Connect Google Sheets to Konnectify and keep your spreadsheet data moving across your stack—automatically.
Get started free →
