Write Data

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.

---

​

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

Append:

• Adds new data to the end of existing data
• Preserves all historical records
• Great for accumulating data over time

Clear Sheet Before Writing:

• 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

Select Specific Columns:

• 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

Column Format: Use A, B, C, D… (not A1, B1, etc.)

---

​

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

Result: Complete campaign data written with headers.

​

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)

Result: New data added to end of existing records.

​

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

Result: Sheet completely cleared, then populated with new data and headers.

​

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

Result: Data written to specified columns only.

---

​

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?

• 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'?

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?

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?

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?

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?

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?

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?

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?

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?

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:

1. Find the service account email: Click on any Google Sheets, Docs, or Slides node in your workflow
2. Look for “Show connection instructions” - click this link
3. Copy the service account email provided (it looks like: something@markifact.iam.gserviceaccount.com)
4. 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”

Important: This same service account email works for Google Sheets, Google Docs, and Google Slides. You only need to find it once from any Google node’s connection instructions.Still having issues? Make sure you’re sharing the exact spreadsheet URL/ID that you’re using in your workflow, and that the service account has “Editor” permissions (not just “Viewer”).