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?