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.

Hello all,

I have an issue setting up GoCanvas corrrectly with Google sheets. 

I created a checklist in GoCanvas for in house services for the individual products. 
My goal is to import every checked product to a single row.

Right now, the products get listed all in one google sheets cell, separated with a “,”.
Not only the serial number, but also the product name, hospital, date, ect. are displayed separated by a comma.
Is it possible to list one product per row? Even if various products are being checked in one day and the information like hospital, date, etc. repeats itself?

Can someone of you please tell me how I can set up the “row per product” view in google sheets?

I would appreciate your help.

Thank you very much.

Hi there @PascalOertel,

Welcome to the Community! 🎉

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the “Action” section of the action step that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

Hi there!
yes of course. This is the configuration:

I think it is not quite right, that I use the create one row, because I need more than one. But I did not find the right step..

 

Hi @PascalOertel,

Thanks for the update here.

Have you tried using the “Create Multiple Spreadsheet Row” action? This action has line item support that could fit your needs.

dbc6d67029fe6972e9be0d220281ed2e.png
(view larger)

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hello Ken,
Thank you for that. 
For now, this is all I need. :) 

Now every single product gets its own row. 

Greetings,
Pascal

You are most welcome @PascalOertel! I’m glad I was able to point you to the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Terms & Conditions