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.

My use case: I have a google sheet with logs for lots of different campaigns, and I need to copy the logs for each value in a different sheet. I don’t want to use branches because there are a lot of values, so I’d like to use the custom value for the worksheet ID.

I used the gid for the worksheet here (i tested and the id works), but

1/ no values show up, so I don’t have any way of mapping what data goes in the sheet and where

2/ when I ran the zap I got an id and a row, and no data actually pushed in the sheet...

Please help!

alivia

Hi @alivia - thanks for writing to us! Happy to help.


I saw you received an answer back from Doyle from Zapier support earlier today. So that we can make sure our friends on the community also see the solution, I will share it here:

You can use a Formatter step in your Zap to isolate this GID number: https://zapier.com/help/create/format/modify-text-formats-in-zaps

The "Split Text" function could looks for #gid= and return only the content after this — this would isolate the worksheet ID number.

Setting up the "Create Spreadsheet Row" step in your Zap will still be a bit strange. It would require selecting a specific worksheet, to show your Zap the column headers of the worksheet. You could use these column headers to set which info will be sent to which columns. After connecting these columns, you can then select "use a custom value". The connections to the columns will remain in tact.

Your Zap can only reliably create rows in Worksheets that will always use the same column headers 

 

Let us know if you have any further questions!

Terms & Conditions