Paragon
Home
Search…
Paragon
Paragon Automate
What is Paragon?
Getting Started
FAQ
What's new in Paragon
Building Workflows
Triggering workflows
Working with integrations
Making API Requests
Working with Functions
Using Conditionals
Using Fan Out
Sending a Response
Viewing Task History
Version History
Auto-Retries
Configuring OAuth
Resources
Integrations Catalog
PostgreSQL Integration
MySQL Integration
MongoDB Integration
Firebase Integration
DynamoDB Integration
SendGrid Integration
Mailgun Integration
Slack Integration
Twilio Integration
OneSignal Integration
Intercom Integration
Klaviyo Integration
Airtable Integration
Google Sheets Integration
Google Drive Integration
Google Calendar Integration
Stripe Integration
QuickBooks Integration
Salesforce Integration
HubSpot Integration
JIRA Integration
Zendesk Integration
FTP Integration
Tableau Integration
Asana Integration
Zoom Integration
Pardot Integration
Marketo Integration
Microsoft Dynamics 365 Integration
Microsoft Teams Integration
Xero Integration
Google Campaign Manager 360 Integration
Outreach Integration
Mailchimp Integration
Facebook Ads Integration
Trello Integration
Oracle Financials Cloud Integration
Azure DevOps Integration
Google Search Console Integration
JavaScript Libraries
OAuth Providers
Tutorials
Engage inactive users by email
Process Stripe cancellations
Sync Airtable to Webflow CMS
Personalize welcome emails
Managing Your Account
Setting up Environment Secrets
Working with Team Members
Managing Integrations
Billing
Understanding Tasks
Security
Security
GDPR
Service Level Agreement
Powered By GitBook
Google Sheets Integration
Connect your Google Sheets account to Paragon.

1. Add Google Sheets to Paragon

Click the "+" button in the workflow canvas and choose Google Sheets from the sidebar. Under Connect your Google Sheets account, choose "Add new account for Google Sheets" and select the Google account you want to connect to.

2. Query Google Sheets

Once your Google Sheets account is connected, you can add steps to perform the following actions:
  • Get rows from spreadsheet
  • Create rows in spreadsheet
  • Update rows in spreadsheet
  • Clear rows in spreadsheet
When using Google Sheets, you'll need to select the Spreadsheet and Worksheet you want to connect to. You'll need to make sure that the sheet you're connecting to has properly formatted column headers and a locale set to "United States". To do this, go to File > Spreadsheet settings, and select "United States" in the locale dropdown.
When creating or updating rows in Google Sheets, you can reference data from previous steps by typing {{ to invoke the variable menu.
​
Previous
Airtable Integration
Next
Google Drive Integration
Last modified 1yr ago
Copy link
Contents
1. Add Google Sheets to Paragon
2. Query Google Sheets