Best answer

Google Sheets Error: Unable to parse range: 'Disputed claim'!3GTO-FBEAbM:3GTO-FBEAbM

  • 13 April 2024
  • 5 replies
  • 21 views

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.

icon

Best answer by Troy Tessalone 13 April 2024, 21:32

View original

5 replies

Userlevel 7
Badge +14

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:
 

 

Userlevel 7
Badge +14

@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
​​​​​​


 

Userlevel 7
Badge +6

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