Skip to main content

I am using a zap to export the card name and description of a trello card to google sheets but want to further process the exported data automatically. To achieve this I am using a regexextract and want the formular to automatically appear next to the exported description.

Since this export constatly creates new rows, I can’t put the formular into the column that needs to be filled and updating spreadsheet rows also only lets me select a single row to be updated. I tried using lookup but that only returns a true or false value instead of the row ids that I want to be updated. Is there actually a way to select a range of rows to be updated? Any symbols that work in google sheets when selecting multiple cells get ignored by zapier so 2:20 turns into 220 for example. 

Or is there a reliable way to export the trello data to the next empty google sheet row without creating a new one?

Hi @EF_SQ 

Add the formula to the input field in the Zap step.

Help:

https://community.zapier.com/featured%2Darticles%2D65/creating%2Dgoogle%2Dsheets%2Drows%2Dwith%2Darray%2Dformulas%2D11912