About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

How do I update a google sheets file path in a zap?

  • 26 July 2022
  • 1 reply
  • 64 views
J

Ok, So even after searching, I cant seem to find a same problem as mine. (possibly my search skills, so sorry if this answer exists)

The scenario is as follows: 

I have a trigger (saving data) that will then write a row with several fields to a google sheet. Then, same trigger, writes another row and so on. 

However, if a specific field changes, then we need to start a new sheet, and use that until the field changes, then the same again, start a new sheet. 

Basically, we are creating “batches” in one sheet, that will be used elsewhere later. 

 

So, how do I change the path in the zap to the new sheet each time? 

icon

Best answer by Danvers 26 July 2022, 12:53

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Danvers
Userlevel 7
Badge +12

Hi @Jussi S!

Hmm, this is a tricky one, but I think it’s technically possible. As I understand it, you have two main challenges:

  1. You need the Zap to recognize the previous row and compare it to the new row, then take a different path based on the whether or not they are the same
  2. If the values are different, you need to create a new sheet and then create rows in the new sheet

Have I got that right?

For the first one, you can do that using a Lookup Spreadsheet Row step and a Path. Use the Lookup Spreadsheet Row to search the relevant column and for the search value, use the field that will be going into it (ie the data for the new row). There’s a field in the output of the step called ‘Zap data is found:’, if the information from the trigger matches a cell currently in the column, that will say ‘True’ and if there are no matching values, that will say ‘False’. Then add your Paths to the Zap, one Zap should continue if the data was found (and go on to add the row as usual) the other path should continue if the data found is ‘False’ (ie the new data doesn’t match the existing data) then create a new sheet and add the row two it. 

 

The second point is trickier because it involves a workaround. You would need to create the sheet in one step and then use the ID of that sheet to tell Zapier which Google Sheet to add the new row to, which currently involves a workaround. There’s a description of the workaround in this post: 

 

I recommend testing that workaround first as it isn’t always reliable, I’m sorry about that!

 

I think that solves the main points of what you’re trying to do - what do you think, can you get your Zap up and running with that?

 

Terms & Conditions