Google Sheets
Write Data
Send data from your workflows to Google Sheets spreadsheets.
Write Data takes data from previous workflow nodes and writes it to your Google Sheets spreadsheets. Essential for saving advertising reports, analytics data, or any processed information to your sheets for storage and analysis.
Column Format: Use A, B, C, D… (not A1, B1, etc.)
Inputs
| Field | Type | Required | Description |
|---|---|---|---|
| Spreadsheet URL/ID | Text | Yes | Google Sheets document link or ID |
| Working Sheet | Select | Yes | Which sheet tab to write to |
| Write Mode | Select | Yes | Overwrite existing data or append to end |
| Starting Row | Number | Yes | Row number where data writing begins |
| Data Mapping | Select | Yes | Use all data or select specific columns |
| Data | Data | Yes* | Data source from previous nodes (*Required for “Use All Data”) |
| Column Mapping | Mapper | Yes* | Map data to specific columns (*Required for “Select Specific Columns”) |
| Add Headers | Switch | Yes | Include column headers in the output |
How It Works
This node takes structured data from previous workflow nodes (like Google Ads, Analytics, etc.) and writes it to your specified Google Sheets location. You can either write all the data automatically or map specific fields to chosen columns.Write Mode Options
Overwrite (Default):- Replaces existing data starting from your specified row
- Keeps data above your starting row intact
- Perfect for updating specific sections while preserving headers
- Adds new data to the end of existing data
- Preserves all historical records
- Great for accumulating data over time
- Removes all existing data from the entire sheet first
- Then writes new data starting from your specified row
- Perfect for complete sheet refreshes and clean starts
Data Mapping Options
Use All Data (Recommended):- Automatically writes all data from previous nodes
- Maintains original column structure and names
- Simplest option for complete data transfer
- Choose which data fields go to which sheet columns
- Customize column order and selection
- Perfect for targeted data placement
Column Mapping Guide
When using “Select Specific Columns”, map your data like this:| Column | Data Field | Example |
|---|---|---|
| A | Campaign Name | Google Ads campaign names |
| B | Clicks | Click count data |
| C | Cost | Spend amounts |
| D | Date | Report date |
Configuration Examples
Save Google Ads Report
Scenario: Write Google Ads campaign data to a tracking sheet Configuration:- Spreadsheet URL/ID: Your tracking spreadsheet link
- Working Sheet: “Campaign Data”
- Write Mode: “Overwrite”
- Starting Row: 2 (keeps headers in row 1)
- Data Mapping: “Use All Data”
- Data: Connect from Google Ads Get Report node
- Add Headers: On
Append Daily Metrics
Scenario: Add today’s performance data to historical log Configuration:- Write Mode: “Append”
- Starting Row: 1 (irrelevant for append)
- Data Mapping: “Use All Data”
- Add Headers: Off (headers already exist)
Complete Sheet Refresh
Scenario: Replace all data with fresh weekly report Configuration:- Write Mode: “Clear Sheet Before Writing”
- Starting Row: 1
- Data Mapping: “Use All Data”
- Add Headers: On
Custom Column Layout
Scenario: Write only specific metrics to predefined columns Configuration:- Data Mapping: “Select Specific Columns”
- Column Mapping:
- A: Campaign Name
- C: Clicks (skipping column B)
- E: Cost
- Add Headers: On
Best Practices
Sheet Preparation
- Set up headers in row 1 before automation
- Use consistent column names across workflows
- Format columns appropriately (currency, dates, numbers)
- Keep backup copies of important sheets
Write Mode Selection
- Use Overwrite for reports that update specific sections
- Use Append for accumulating historical data
- Use Clear Sheet Before Writing for complete data refreshes
- Set Starting Row to 1 when clearing entire sheet
- Set Starting Row to 2 when preserving existing headers (Overwrite mode)
- Test with small data before full automation
Data Mapping Strategy
- Start with “Use All Data” for simplicity
- Use “Select Specific Columns” for custom layouts
- Map important fields first (dates, identifiers)
- Keep column mapping consistent across workflows
Header Management
- Turn on “Add Headers” for new sheets, clear mode, or overwrite mode
- Turn off “Add Headers” when appending to existing data
- Use descriptive header names for clarity
- Match header names with your data source
- Clear mode always removes existing headers - turn on “Add Headers” to replace them
Credit Cost
1 credit per successful run.FAQ
What's the difference between the three write modes?
What's the difference between the three write modes?
- Overwrite replaces data starting from your chosen row, keeping data above intact - good for updating sections.
- Append adds new data to the end - perfect for historical tracking.
- Clear Sheet Before Writing removes everything then writes fresh data - ideal for complete weekly/monthly refreshes without needing a separate Clear Data node.
When should I use 'Use All Data' vs 'Select Specific Columns'?
When should I use 'Use All Data' vs 'Select Specific Columns'?
Use ‘Use All Data’ when you want everything from your data source - it’s simpler and includes all fields automatically. Use ‘Select Specific Columns’ when you need control over which data goes where, or when your sheet has a specific layout to follow.
When should I use 'Clear Sheet Before Writing' vs the separate Clear Data node?
When should I use 'Clear Sheet Before Writing' vs the separate Clear Data node?
Use ‘Clear Sheet Before Writing’ when you want to replace all data in one step - perfect for weekly/monthly report refreshes. Use the separate Clear Data node when you need more control - like clearing specific ranges, or when you want to clear data but not immediately write new data back.
How do I handle headers correctly?
How do I handle headers correctly?
Turn on ‘Add Headers’ for new sheets or when overwriting completely. Turn off ‘Add Headers’ when appending to sheets that already have headers. Set Starting Row to 2 if you want to preserve existing headers in row 1.
What data can I write to Google Sheets?
What data can I write to Google Sheets?
Any structured data from previous workflow nodes - Google Ads reports, Analytics data, Meta Ads performance, etc. The data should be in table format with consistent columns. Numbers, text, dates, and percentages all work perfectly.
How do I know which columns to use in Column Mapping?
How do I know which columns to use in Column Mapping?
Use A, B, C, D… to represent columns (not A1, B1). Look at your Google Sheets - A is the first column, B is second, etc. You can skip columns if needed (map to A, then C, skipping B).
What happens if my sheet doesn't have enough rows or columns?
What happens if my sheet doesn't have enough rows or columns?
Google Sheets automatically expands to accommodate your data. If you’re writing 100 rows of data to a 10-row sheet, it will expand. New columns are also created automatically as needed.
Can I write to multiple sheets at once?
Can I write to multiple sheets at once?
No, each Write Data node writes to one sheet tab at a time. To write to multiple sheets, use multiple Write Data nodes in your workflow, each targeting a different sheet tab in your spreadsheet.
What happens to existing formatting when I write data?
What happens to existing formatting when I write data?
Overwrite mode may clear some formatting in the affected cells. Append mode preserves existing formatting. For best results, apply formatting to entire columns rather than individual cells, and consider doing it after data writing is complete.
I'm getting 'Access denied to Google Sheet' error. How do I fix this?
I'm getting 'Access denied to Google Sheet' error. How do I fix this?
This error means your Google Sheet isn’t shared with our app’s service account. Here’s how to fix it:Error message: “Access denied to Google Sheet. Please share the spreadsheet with the app’s service account email as instructed.”Solution:
- Find the service account email: Click on any Google Sheets, Docs, or Slides node in your workflow
- Look for “Show connection instructions” - click this link
- Copy the service account email provided (it looks like: something@markifact.iam.gserviceaccount.com)
- Share your Google Sheet with this email:
- Open your Google Sheet
- Click “Share” (top right)
- Paste the service account email
- Set permissions to “Editor”
- Click “Send”