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.

 Trying to add call information from Webphone for Voipcloud at the end of calls to google sheets - The sheet has columns with checkboxes in them that are not related to the columns i want the zap to use, but i can not get the zap to work in the rows where columns have the checkboxs.

When i removed the checkboxes so the rows are all empty, the test zap works, then nothing works after I pulblish.

 

 

 

my zap worked in the test but not once published, and i have checkboxes in the columns already and i can not add the data to these rows

Hi @Sarah L 

Zaps create new rows rather than updating existing rows.

e.g. If the GSheet has 10 rows, then the Zap Run happens, the GSheet will have 11 rows.

Formatting from the previous GSheet rows is not kept when a new row is added.

 

An alternative approach would be to use Airtable instead of GSheets.

Thank you for your response.  I am not sure about changing to a completely new system. It does though give me another idea, again, might not be possible, but if I set up the zap to add a new row that is blank, could I then add the checkboxes and other rules I have set up currently to be added automatically once the row has been generated?  Through Google Apps Script or something?  Do you know anything about the possibility of this?

@Sarah L 

Available GSheet Zap app triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Zap action: GSheets - Format Row

Otherwise, you would have to explore using GAS (Google App Script) or the GSheets API.

 

 

 

Hi @Sarah L 👋

Were you able to sort things out using a Format Spreadsheet Row action, API Request action or Google App Script? 

Or did you find a different solution? Would love to know whether you’ve got this solved or not - happy to lend a hand if you’re still stuck at all. 

Looking forward to hearing from you!

Terms & Conditions