All Google Sheets rows copied to Smartsheet, but only first row shows.

Question

I have a Zap that takes the multi row submission collected on GoCanvas, copies it to Google Sheets and then takes the same information and copies it to a SmartSheet sheet.

The issue; the transfer from GoCanvans to GSheets works - all rows copied, however, only the he first row of the submission appears on Smartsheet.

The GSheet → SSsheet Zapier event states “row” where the GCanvas to GSheet states “rowS” - could this be the issue and if it is, how does one make a GSheet → SSsheet event for “rowS”?

Thank you

icon

Best answer by nicksimard 11 May 2022, 22:54

View original

nicksimard · Accepted Answer

Hi @MattA!The Smartsheet integration doesn’t have that same option, to create multiple rows at once.You can get around that by using Looping by Zapier. You can check out this section of an article we wrote, about how to use line items (which is likely what you’re getting from GoCanvas) with Looping:Once you’ve put your data through Looping, you add the Smartsheet step and for every line item that comes from your trigger step, the Zap will add a row to Smartsheet.NOTE: make sure when you’re mapping the fields that come from the Looping step, that you don’t use the ones that have “preview” as part of the name.Hope that helps!

Troy Tessalone · Answer

Hi @MattAGood question.You can use Looping to handle line items: https://zapier.com/apps/looping/helpSo you could go from GoCanvas directly to Smartsheet.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded