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 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.

  • Home
  • Get Help
  • How Do I
  • How to add a Google Sheet row to another custom sheet whose url is included in a column
Best answer

How to add a Google Sheet row to another custom sheet whose url is included in a column

E
Userlevel 1

Hi there, 

I’m trying to set up a Zap that will accomplish the following:

  • A Google form response is submitted, which creates a new row in a spreadsheet
  • One of the columns of this spreadsheet has a url to another Google sheet
  • I want to add the row that was created in the first sheet to the specific Google sheet with the url indicated in the first sheet’s column

I’ve tried using the “custom” option and selecting that column of the spreadsheet as the sheet to send the action to, but I receive a 404 error message. 

Can anyone help with this?

icon

Best answer by Troy Tessalone 30 May 2022, 16:33

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.

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @emilycorrigan

Good question.

Please reference this related topic:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Userlevel 7
Badge +12

Hi @emilycorrigan!

The article that Troy has linked to above explains how to use a custom value as the Spreadsheet when working with Google Sheets, that should get you to where you need to be. Let us know if that works for you! 😄

Terms & Conditions