Hey all, thanks in advance for any insight into figuring this one out.
I’m using the “Get Many Spreadsheet Rows (Advanced, With Line Item Support) in Google Sheets” Zap and the output I get is either “Rows” or “RAW Rows.” Then I’m using the Zapier format Text Zap to remove all of the “$” from the output. Then ultimately I’d like to create new spreadsheet rows in an existing Sheets doc using this data but I’m having some trouble with how to work with the output I’m given. I’d like to take the data and have it show up in the proper columns in the new rows.
I’ve tried using the Post Webhook to format as a list, but I’m not sure how to separate the comma’d array into what would show as separate fields that I cal work with and insert into my Sheets Doc.
I’m not a total noob so I should be able to interpret what you guys throw at me, but some assistance would be appreciated.
BONUS QUESTION: If my spreadsheet with line items happens to be more than 20 rows (max allowed in this zap), can I setup a second Filter zap that searches my original source Sheets doc starting at line 21, only runs if there is data entered in that row or after, then Gets that data from rows 21-41, and finally creates additional rows in my final Google sheets doc if they existed in the source doc?
Best answer by DanversView original