Copy all data after row 3 in a google sheet to another sheet

Bump

Hi @casedog3000 I’m sorry for the delay in getting back to you on this!

Is there anything in the rows of data that is never in the header rows? For example, do the rows have an email address in? And what’s the maximum number of rows that you might have in a day? If there’s not more than 10 rows, then you could use the Google Sheets Find Many Spreadsheet Rows (With Line Item Support) action. You would use a search that would only find the data that you want and not the header rows (for example, if the rows have email addresses in them, you could search for an ‘@’). That would get the data that you want and not the header row, that you could then use with the action Create Spreadsheet Row(s) to add the rows to your other sheet. 

I hope that helps!

@Danvers Thank you so much for the help! I would say that more than 10 rows doesn’t happen that often but it does occasionally… is there any way to check if row has any input whatsoever to pull that data and copy it to the other spreadsheet? I do see the Advanced “Get” option that will do 20 rows max. I do have a column that is delivered with true or false, I only collect data from the rows that return “false” in the last column. Could I have it return, then copy every row that is false using a filter, even if there are more than 20 rows?

@casedog3000 Having it look for every row with ‘False’ in it sounds like a good approach. Even using the Get Many Spreadsheet Rows action, the Zap will only be able to find the first 20 rows that meet the search criteria, so if there were more than 20, it wouldn’t find those extra rows. 

One thing to mention about the Get Many Spreadsheet Rows  action is that it returns the information as a single JSON value and flat rows (line items), so you’ll need to know how to work with that in the next step of the Zap. It is possible, it just requires a bit more technical know-how 🙂

Much appreciated. Maybe you can point me in the right direction even further?

Right now I took that json file and used the Webhooks Zap to POST to a custom zapier URL (from the Catch Webhooks trigger), I’m building the data table in my POST Webhooks zap but I’m unsure how to format the output from the json to fill in the data. I’ve named all of my columns on the left so I can put them in the final fields on my spreadsheet, but not sure how to fill in the field on the right to extract the data from the rows in the json. I’ll use whats posted to the CATCH Webhooks trigger to fill in be spreadsheet rows.

Is there maybe a different way to do this? I’m fairly technical and can figure it out if you can show me the resources you recommend. Thank you!

I’m not super familiar with the output of the Get Many Spreadsheet Rows action as I’ve not used it myself. 

If it looks like a standard line item array then you might not have to send it off to a different Zap. You can add a Google Sheets Create new Spreadsheet Row(s) action into the Zap, which will add a new row (in your other sheet) for each line item. 

If it looks like the data will need some extraction, then you will likely need to use a code step to do that. If you have any questions about the set up of webhooks or code steps, then posting a question in the Developer Discussion category is a good place to start! 

Hi @casedog3000!

I wanted to check in with you on this one, since we didn't hear back after our last message. Did you still need help here or were you able to resolve things? Please let us know :)

Thanks for checking in! I ended up hiring someone to do it using google script outside of zapier.