I saw a post you wrote about using Google sheets is an intermediate step between two zaps (
) and your example of an invoice with line items is similar to what I'm challenged with. Can I ask you a couple questions and lean on your expertise?
I have a sheet in Smartsheet that holds the data needed for a scope of work document. Some of that data only needs brought in once (i.e. client name, date, invoice code) and the other data is an array (like you said in your post as an example, multiple rows that need to go into a table).
I was looking at FormStack, but they can't do an array/multiple lines through Zapier. You mention Airtable and Google Sheets - so are you saying that you have your data in one place (similar to me having my data in Smartsheet) and you send it through one zap to Google Sheets, then Google Sheets can put it in the Airtable (either a row or an array/multiple rows)?
I'm a super new beginner to Zapier but I'm stumped trying to find a solution that will work... I'm hoping your post seems to hold the key, but I'm not quite sure I understand it correctly.
Best answer by PaulKortmanView original