Answered

Synchronize Excel with Google Sheets

(0) Share

Report

Posted on by matmat

Hello all,

I would like to transfer data from an Excel file stored on OneDrive to a Google Sheet. In another post I saw this setup (see screenshot). In my case, however, not the values but some IDs are entered in the Google Sheet.

The following structure
1) List rows present in a table
2) Apply to each - inser row

I would be glad if you could suggest a solution.
Best regards

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @matmat
Those values will come.
Though before doing this step, you had to make columns in google sheet.
You will have to predefine columns, then only it will work.
Like you have a columns Name and Email in your excel, you will have to make those columns in your google sheet too.

Was this reply helpful? Yes No
matmat 26 on at

Like (1)

Report

Hi!
Thank you for the tip. It was the solution to my problem. For the others, here is a screenshot of the settings.

Was this reply helpful? Yes No