web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel - Google Sheets ...
Power Automate
Unanswered

Excel - Google Sheets range function

(0) ShareShare
ReportReport
Posted on by 26

Hi all,

 

My flow transfers data from Excel to SharePoint and enters it into a google sheet. The data in the Excel is updated daily. The flow currently has 3 problems.

 

A) Extremely slow

B) Inaccurate because it is not variable.


I am looking for better functions or ideas to improve the flow.

This is product data. New rows are added from time to time, some are removed, daily the inventory of products changes and the product texts are also updated regularly.

 

Process:
1) Create Excel list (time defined automation).
2) Start PA Flow
3) PA: Retrieve tables and cells.
4) PA: Then delete based on ID with a loop starting from row 2. (To ensure that all data is new).
5) PA: Retrieve Excel
6) Transfer all values individually to Google Sheets

 

To A)
The whole process takes about 1.5 hours. Deleting takes a long time because all rows are addressed individually.
Is it possible to define a range in Power Automate to delete the entire range (except the table headings)? I have not found anything equivalent to last column/row in Excel.

 

To B)
Since I haven't found a function like last column, I have to enter exactly how many rows I want to retrieve. But since the excel is variable, I also want the function to adjust to the number of rows present. There are currently 431 rows. As far as I know, you have to define the number of rows from 255 /256 with the pagination.

 

Do you have any other ideas on how to make the Excel-Google Sheets synchro?

power-automate-flow-google-excel.jpg

 

I would appreciate any ideas!

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard