Google Sheets
Create, edit or capture updates to Google Sheet right within your workflow and perform any complex automation workflow easily
Version: 2.0.2
Supported triggers and actions in Google Sheets
Workflow is a set of actions. Trigger is an event that starts the workflow, and an action is an event that is executed by workflow to sync data with your app.
When this happens..
New Spreadsheet Row
Trigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet Row
Trigger when a row is updated in the spreadsheet
Deleted Spreadsheet Row
Trigger when a row is deleted from the spreadsheet
Update Cell Data
Trigger when any cell is updated in the spreadsheet
Update Specific Cell Data
Trigger when a specific cell is updated in the spreadsheet
Update Specific Column Value
Trigger when a specific column value is updated in the spreadsheet
Do this..
Add New Row
Add a new row with mapped data
Update Row
Update existing row in specific spreadsheet with mapped data
Delete Row
Delete row by ID in specific spreadsheet
Clear Row Data
Clear data or row by ID in specific spreadsheet
Lookup Row Data
Search for data in specific spreadsheet
Get Cell Data
Get data for particular cell in specific spreadsheet
Update Cell Data
Update data for particular cell in specific spreadsheet
Get Row Count
Get total number of rows in specific spreadsheet
Get Row Data
Get rows data from the sheet based on specified range
Create Spreadsheet Column
Create a new column in specific spreadsheet
Create New Sheet
Create a new sheet in specific spreadsheet
Import CSV or JSON to Existing Sheet
Import CSV or JSON data to existing sheet in specific spreadsheet
Copy Sheet
Copy a sheet to another or within the same spreadsheet
Workflow Examples
Workflow Name | Applications |
---|---|
When Contact Form 7 is submitted, add form submission as Google Spreadsheet row |
|
When Elementor Pro form is submitted, add form submission as Google Spreadsheet row |
|
When WPForms form is submitted, add form submission as Google Spreadsheet row |
|
When new submission is captured in Typeform, add form submission as Google Spreadsheet row |
|
When new post is published in WordPress, add the post details as Google Spreadsheet row |
|
When a new order received in WooCommerce, add the order details to Google Spreadsheet |
|
Connect Google Sheets With The Following
WordPress Plugins And 3rd Party Apps
123 Form Builder
99Acres
Activechat
Acumbamail
Advanced Custom Fields
AidaForm
Airtable
Albacross
Anthropic (Claude)
API Module
API Polling
Appcontx
ARForms
ARMember
Avada Forms
BananaShop
Beaver Builder Forms
Better Uptime
Bitly
Book Like a Boss
Bounceless
Box
Brevo ( Sendinblue )
Bricks Forms
BuddyBoss
BuddyPress
Buy Me a Coffee
CallRail
Campaign Monitor
Canva
Chatrace
ClickUp
Cloudflare
Contact Form 7
Continual.ly
ConversioBot
Convertbox
Counter
Creatomate
Crove
CSV Parser
Custom Action
Date/Time Formatter
Delay
Desku.io
Discord
Divi Forms
Easypromos
Elementor
Email List Validation
Email Parser
Email SMTP
Emailable
EmailListVerify
Facebook Lead Ads
Filters
Flowlu
FlowMattic Tools
Fluent Booking
Fluent Forms
Fluent Support
FluentCRM
Formaloo
FormCrafts
Formidable Forms
Forminator
Formium
Freshdesk
FunnelKit Automations ( Autonami )
Fusioo
GamiPress
Gmail
Google AI
Google Drive
Google Lead Form
Google Sheets
Gravity Forms
Groove Pages
Groove Sales
Groq AI
Groundhogg
HARO Email Parser
Hexomatic
HeySummit
Hotmart
HubSpot CRM
Instantly
Instantpage.dev
Integrately
Iterator
Iterator End
Iterator Storage
Jotform
Kadence Forms
KonnectzIT
LatePoint
LeadConnector V2
LearnDash
Lemon Squeezy
Listnr
Mailbluster
Mailboxlayer
Mailchimp
MailerLite
MailPoet
MailRefine
MainWP
Make
MakeForms
MasterStudy LMS
Maths Module
Metabox
Metabox – Custom Table
Monday.com
myCred
n8n.io
NeuronWriter
NewOaks AI
Nifty PM
Ninja Forms
NinjaPipe
Notion
Nuelink
Number Formatter
Ocoya
OpenAI (ChatGPT)
OpenRead.io
OpenRouter AI
Optinly
OptinMonster
Outgoing Webhook
Pabbly Connect
Pabbly Subscriptions
Paced Email
Paddle
Paid Memberships Pro
Parsio
PDF.co
PhotoRoom
PHP Array
PHP Functions
Plugin Actions
Presto Player
Probooking
QuestionScout
Radaar
Razorpay
Reoon Email Verifier
Replug
Restrict Content Pro
Routers
RSS Feed
SavvyCal
Schedule
ScreenshotOne
Sessions
Shopia
Slack
Smartsheet
Socialbee
Sociamonials
SpreadSimple
Straico
Stripe
SureCart
SureMembers
Swipe Pages
Tawk.to
Telegram
Text Formatter
ThriveCart
ThriveDesk
Todoist
Tomba
TradingView
Trafft
TuCalendi
Tutor LMS
Twilio
Typebot
Typeform
Unbounce
UpViral
VBOUT
VerifyBee
Voxel
Webhook Response
Webhooks
Webpage Parser
WhatsApp by WA.Team
WhatsApp Cloud API
Wise
Wishlist Member
WooCommerce
WordPress
WP All Import
WP Amelia
WP Fusion
WP-Polls
WPForms
WSForms
X ( Twitter )
XML Parser
Zapier
Zeeg
ZeroBounce
Google Sheets integration changelog
v2.0.2 – 6 August, 2024
– Fix: Webhook cron renewal causing issue if the cron job is not working fine in WordPress
– Fix: Set default authentication type for the new Connect vs traditional method in workflow
– Fix: Actions not working if the Spreadsheet or the worksheet has Emoji or special characters in name
v2.0.1 – 26 Jun, 2024
– Fix: Update Cell data action causing conflict if the data has comma separated content
v2.0 – 12 June, 2024
# New
– Implemented FlowMattic Connect to use centralized connections
– Trigger: New Spreadsheet Row
– Trigger: New Or Updated Spreadsheet Row
– Trigger: Deleted Spreadsheet Row
– Trigger: Update Cell Data
– Trigger: Update Specific Cell Data
– Trigger: Update Specific Column Value
– Action: Get Row Count
– Action: Create Spreadsheet Column
– Action: Create New Sheet
– Action: Import CSV or JSON to Existing Sheet
– Action: Get Row Data
– Action: Copy Sheet
# Improvements
– All the existing actions are improved to work fine with existing setup and new setup
# Fixes
– New row action insert from 3rd row
– Sheet data was not available above 10,000 rows
– Sometimes the cell update was happening on cell A due to provided range is incorrect
– Add row action does not allow to have empty column fields
– Add row action causing error if the sheet name has special characters or quotes
v1.1.1 – 19 Jan. 2023
– Fix: Escape single and double quotes correctly when add or update data to Google sheet
v1.1.0 – 15 Nov. 2022
– New action – Update Row
– New action – Delete Row
– New action – Clear Row Data
– New action – Lookup Row Data
– New action – Get Cell Data
– New action – Update Cell Data
v1.0
– Initial release