I am trying to set up a zap to update my google sheet rows whenever their is a change in leadconnector pipeline stage but I have been getting an error
There was an error writing to your Google sheet. Unable to parse range: 'Data'!Needs Rescheduled:Needs Rescheduled”
Best answer by christina.dBest answer by christina.d
Hiya friends! I wanted to swing by and summarize what we have here so far:
Troy offered this up as a potential zap setup:
You may need separate Zaps.
We also have some guides and resources for troubleshooting along the way here:
I hope this helps! 😃 Keep us posted on your success, Dustin!
+14Hi
Good question.
Have you reviewed the available help articles for using GSheets with Zaps?
+9Hey there,
Sorry to see you’re getting that error. Do you mind sharing your current zap setup? This may help us to get to the root of this with ya.
In the meantime I might recommend checking out this help doc.:
https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#im-seeing-an-errors-that-mention-range-cannot-parse-range-requested-writing-within-range
Looking forward to getting this sorted with you!
Okay the ID field in the update action works but the new problem is when the field is updated from leadconnector, it keeps the original entry and just fills the new details into the row number
Below is the setup
Hey there,
Sorry to see you’re getting that error. Do you mind sharing your current zap setup? This may help us to get to the root of this with ya.
In the meantime I might recommend checking out this help doc.:
https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#im-seeing-an-errors-that-mention-range-cannot-parse-range-requested-writing-within-range
Looking forward to getting this sorted with you!
+14Please clarify what you are expecting to happen for this:
Okay the ID field in the update action works but the new problem is when the field is updated from leadconnector, it keeps the original entry and just fills the new details into the row number
Please clarify what you are expecting to happen for this:
Okay the ID field in the update action works but the new problem is when the field is updated from leadconnector, it keeps the original entry and just fills the new details into the row number
Whenever there’s a new lead it enters into the first pipeline stage, then into to spreadsheet. Then when the contact is moved to the subsequent pipeline stages, I want the stage column in the spreadsheet to get updated without changing other columns
+14You may need separate Zaps.
+9Hiya friends! I wanted to swing by and summarize what we have here so far:
Troy offered this up as a potential zap setup:
You may need separate Zaps.
We also have some guides and resources for troubleshooting along the way here:
I hope this helps! 😃 Keep us posted on your success, Dustin!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
