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.

I’m trying to set up a Zap where I add a new row to Smartsheet, then a new document is created from a Google sheet template and the information is added to particular cells. If I were sending an entire row over it would be easy, but my issue is that I want to keep Smartsheet set up as a row/column system, and essentially fill in a form I have created using Google sheet with that information. At the end of each project, that form gets printed and signed by our company and the client. So the google sheet (form) really needs to maintain a professional face. I can’t just print a long row of information. So for every row, i would have a corresponding google sheet that is easier to read than a single row of information.

I want to use Smartsheet because i can keep all of my projects organizes without flipping through the printed forms. Also Smartsheet allows me to set up date reminders so that I dont miss deadlines (which continues to happen when i just fill in the paper copy of the form.

 

Please provide a screenshot of what the GSheet form looks like.

GSheet looks like this. A little more below the screenshot cut off but essentially the same. I want my Project managers to be able to go into Smartsheet and enter the data in a single row per project and have the data populate this form. So new Smartsheet row = new form. So I’m looking for something (SS=smartsheet; GS=GoogleSheet) like SS column 1 populates GS B4, SS column 2 populates GS D4, SS column 3 populates GS B6, etc...

 

You’d have to use a helper tab in the GSheets.

Data can only be sent as a row, not to individual cells.

Essentially, you’d send data as a full row to a (hidden) helper tab, always to Row 2.

Then in the GSheets you’d maps via reference formulas the data in the columns on the helper tab to the cells in the main tab.

It may not display as expected, so you could have to merge some cells in the main table and/or wrap some cell values, etc.

###

Here’s an article how to create a GDocs Template that may be worth trying: https://zapier.com/blog/create-autopopulate-google-docs-template/

Or you can look into creating and using a proper form creator that integrates with Zapier.

 

Thank you! I’ll take a look! Even if this doesn’t workout, it gave me a backup idea!

Terms & Conditions