Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

In a task, I am trying to connect Airtable to Google Sheets.

The Airtable and Google Sheet have similar columns and I want whenever I update a field in my Airtable, I want the same data is updated (for that particular row) in google sheet also. But I am facing this error when I mapped the columns:


Failed to create a spreadsheet row in Google Sheets
There was an error writing to your Google sheet. Unable to parse range: 'Disputed claim'!3GTO-FBEAbM:3GTO-FBEAbM

 

So here is my ZAP Flow:

  • New or Updated Record in Airtable (Trigger)
  • Lookup Spreadsheet row in Google Sheets (Action #1)
  • Update Spreadsheet row in Google Sheets (Action #2)

Airtable Columns:

  • id
  • Your Decision (single select)
  • Issue ID (Single Line Text)
  • Expiry Date (Date field)
  • Notes (Long Text)
  • Reason (Long Text)
  • UPC (Number Field)
  • ISRC (Single line text)
  • Asset Name (Long Text)
  • Asset Type (Single Line Text)
  • Asset Created On (Date, default=current date)
  • Custom ID (number)
  • Views Affected Daily (Number)
  • Views Lifetime (Number)
  • Claimed Videos Affected (Number)
  • Other Party (Single Line text)
  • Video ID (Single Line Text)
  • Video Title (Long Text)
  • Channel Name (Single Line Text)
  • Channel ID (Single Line Text)
  • Duration Time (Seconds) (Number)
  • Duration Percentage Reference (Number)
  • Duration Percentage Video (Number)
  • Match Type (Single Line Text)
  • Status (Single Line text)
  • Asset ID (Single Line text)
  • Claim ID (Single Line text)
  • Link To Issue (URL)
  • Updated At (Last Modified Time)

Above Trigger Config:

Trigger Config

 

Lookup Spreadsheet Row Configuration (used this to find the row in which I want to update the information inside google sheet, when I change in the corresponding airtable):

Lookup-step-config

 

Update Spreadsheet Row in Google Sheets Config:

update-spreadsheet-record

 

Error:

Error
​

How can I resolve this? Everyone Suggestions are welcomed!

Also, I have already tried to replace: Issue Id from Google Sheets to Issue Id from Airtable, still error is coming.

Hi @vibhudawar 

 

Map the Row or ID variable from Step 2 to the Row field.

 

Hi @vibhudawar 

 

Map the Row or ID variable from Step 2 to the Row field.

 

Hey @Troy Tessalone,

Tried this. But still it didn’t work.
Also, I tried to remove the Lookup step, I felt that it wasn’t necessary to map the fields. Am I right?

Here is my current workflow:

updated-workflow
​​​​​​

Update Spreadsheet Row with fields updated:
 

update-spreadsheet-row fields
​​​​​​

RESULT:
 

 

@vibhudawar 

The GSheets Update Row field for Row expects a Row ID which is a number. (e.g. Row 1 would be a value of 1)

The GSheet Lookup Row step, for found rows, returns 2 variables that can be used. (Row, ID)

 

@vibhudawar

The GSheets Update Row field for Row expects a Row ID which is a number. (e.g. Row 1 would be a value of 1)

The GSheet Lookup Row step, for found rows, returns 2 variables that can be used. (Row, ID)

 

First of all, HUGE THANKS @Troy Tessalone. It worked!

Attaching the solution, for the community!

So, updated the flow, included back the Lookup Spreadsheet Row in Google Sheets step in the flow. Here is the updated flow:
 

updated-flow

Here are the entries in the Lookup Spreadsheet Row in Google Sheets step:

Here are the entries in the Update Spreadsheet Row step:
 

update-spreadsheet-row
​​​​​​


 

That’s great news @vibhudawar! A huge shoutout to Troy for lending a hand here!

Also, thank you for sharing your Zap setup to our Community members!

Happy Zapping! ⚡️

Reply


Terms & Conditions