01
Add Row Node
Map text values to columns, including flow tokens, and write a row to a chosen spreadsheet tab. Values are written as plain text rather than evaluated as formulas.
What You Get
02
Find Row Node
Search for the first row that matches one column, then use the found values in later steps. Found, Not Found and Error are separate outputs, so your flow can branch cleanly.
03
New Row Trigger
Start a flow when a new row appears. Pick a unique ID column and the sheet is checked about every five minutes, starting each flow once for each new ID.
04
Files You Choose
Members select spreadsheets with Google Picker, and the grant covers only files chosen. You pick the spreadsheet and tab in the flow editor and refresh columns after header changes.
05
Safe Writes
An append with an uncertain outcome is not blindly retried, which helps avoid duplicate rows. The result exposes the updated range so later steps can use it.
06
Your Own Google App
You supply a Google Cloud OAuth client, project number and restricted browser API key. Secrets are encrypted and shown masked after saving.
How It Works
Create Your Google App
Enable the Google Sheets, Drive and Picker APIs in Google Cloud, create a Web application OAuth client and add the exact redirect URL shown in Zender.
Install And Configure
Upload the plugin in Admin, enter the Client ID, Client Secret, Project Number and Browser API Key in Configure, then activate it and enable Chat Flows and Google Sheets on the plan.
Connect And Build
Open Integrations, sign in with Google, choose a spreadsheet, then add Add Row, Find Row or New Row steps in the flow editor.
Requirements
- Zender 5.0 or later
- Chat Flows and Google Sheets enabled on the plan
- A Google Cloud project with an OAuth client and browser API key
- Scheduler and queue workers running for New Row flows
- Reads up to 100 columns and 10,000 data rows
- Zender server: PHP 8.4 or later
Frequently Asked Questions
What is Google Sheets Plugin for Zender?
Google Sheets Plugin for Zender is a paid plugin for Zender that lets flows add rows, find rows and start when a new row appears in a Google spreadsheet.
Can the plugin see all of my Google Drive files?
No. The grant requests identity, email and access to only the files you choose through Google Picker. Choose the spreadsheet again if access or the Google account changes.
Why did my New Row flow not start for old rows?
Existing rows are intentionally baselined when the trigger is published, so only rows added afterward start the flow. Use a unique, nonempty ID column, and make sure the scheduler and workers are running.
What happens if an Add Row request times out?
An append with an uncertain result is not retried automatically, to prevent duplicates. Inspect the sheet before you try again, since repeating the action manually may add another row.
Why does my Google connection expire after seven days?
Set the Google consent screen to In production. Testing grants expire after seven days.
Do Extended license holders get a discount?
Yes. Zender Extended license holders buy this plugin at a reduced price. With a Regular license, it is sold at the price shown on this page.
Do I need Zender to use it?
Google Sheets Plugin for Zender is an add-on for Zender and requires a Zender 5 installation. The requirements are listed on this page.
How do I get Google Sheets Plugin for Zender after buying?
After buying, sign in at https://dashboard.titansys.dev with the Envato login button to download it and get support.