Google Sheets
What it does
Section titled “What it does”The Google Sheets node connects your workflows to Google Sheets, allowing you to add rows, update data, or read from your spreadsheets automatically.
Think of it as a data entry assistant that fills in your spreadsheets for you, organizing information in rows and columns without any manual typing.
When to use it
Section titled “When to use it”- You want to collect data from websites into a familiar spreadsheet format
- You need to track metrics, prices, or content over time
- You want to build simple databases or logs that you can share with others
- You prefer working with data in Google Sheets for analysis or reporting
How it works
Section titled “How it works”The node connects to your Google account and accesses your spreadsheets. When triggered, it can append rows to sheets, update existing cells, or read data from your spreadsheets.
graph LR
Workflow[Workflow Trigger] --> Sheets{Google Sheets Node}
Sheets --> Append[Add Row]
Sheets --> Update[Update Cell]
Sheets --> Read[Read Data]
style Sheets fill:#6d28d9,stroke:#fff,color:#fff
Setup guide
Section titled “Setup guide”-
Connect your Google account
- In the node settings, click “Connect Google”
- Sign in with your Google account
- Grant permission to access Google Sheets
-
Select your spreadsheet
- Choose from your existing spreadsheets, or
- Enter the spreadsheet ID from the URL:
docs.google.com/spreadsheets/d/XXXXXX/edit - Select the specific sheet (tab) you want to use
-
Add the Google Sheets node to your workflow
-
Configure the action
- Choose the operation: Append row, Update cell, or Read
- Map your workflow data to specific columns
- For append: specify the header row if your sheet has one
-
Test the connection by running the workflow
Practical example: Content inventory tracker
Section titled “Practical example: Content inventory tracker”Let’s build a content inventory by saving article titles and URLs to a Google Sheet.
What you configure:
- Spreadsheet: Your “Content Inventory” sheet
- Sheet: “Articles” tab
- Action: Append row
- Column mapping:
- Column A (Title): Article title from Get All Text node
- Column B (URL): Page URL
- Column C (Date): Today’s date
- Column D (Source): Website name
What happens:
- Your workflow visits content pages and extracts information
- The Google Sheets node adds each item as a new row
- Your spreadsheet grows automatically with your research
Common settings
Section titled “Common settings”| Setting | Purpose | When to Use |
|---|---|---|
| Spreadsheet ID | Target Google Sheet | Get from the sheet’s URL or select from your files |
| Sheet Name | Specific tab within the spreadsheet | The tab name at the bottom of your sheet |
| Operation | Append, Update, or Read | Choose based on your workflow needs |
| Values | Data to write | Map workflow outputs to column positions |
| Header Row | Row containing column names | Helps match data to the right columns |
Troubleshooting
Section titled “Troubleshooting”- Permission denied: Ensure you granted Google Sheets access during account connection
- Sheet not found: Verify the spreadsheet ID is correct (the long string from your URL)
- Wrong column: Check that your column mappings align with your sheet’s structure
- Authentication expired: If data stops flowing, reconnect your Google account
- Rate limits: Google has API limits; for high-volume workflows, add delays between writes