Unanswered

Copy and paste excel sheet to existing google sheet (2,000+ rows)

(1) Share

Report

Posted on by atorrespm

I built a flow that copies each row of an excel sheet to an existing google sheet, however since the excel sheet has over 2,000 rows of data. The flow takes 1-2 hours to complete and sometimes will run into errors. Please review my flow and help me improve it or create a whole new flow that perhaps doesn't need to go row by row. I created this flow based off of another question posted.

Below is the data for my flow

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi @atorrespm ,

Is the file a complete copy that you want to copy to Google Drive? If so, I agree, looping through rows is not the best option here. If it is a complete copy, I would set up a flow to email it to myself in my Google account and save the attachment on a recurring basis.

Was this reply helpful? Yes No
atorrespm 6 on at

Like (1)

Report

Yes its a complete copy that I want to copy to an existing sheet. It's meant to update a specific sheet, so as of now it just pastes it onto the google sheet and the google sheet has a trigger to remove duplicates.

Was this reply helpful? Yes No