Share
Report
62So I am trying to use @PAG 's solution to Write to Google Sheets API Using OAuth 2.0 Power Automate for Desktop.
And I got the example in the solution to work, but I have data in Excel that I continuously update and would like to use that data to update my google sheets spreadsheet.
For the 'SET SpreadsheetData' action, is there an easy way to convert data in an Excel table to this structure or some other structure that would be acceptable?
Here is the 'SET SpreadsheetData' action from Mister PAG's solution above:
Here is an example of a data table from Excel that I am trying to convert to the correct structure to update my Google Sheets spreadsheet:
| TEST #1 | TEST #2 | TEST #3 | TEST #4 |
| Microsoft #1 | Power #1 | Automate #1 | Desktop #1 |
| Microsoft #2 | Power #2 | Automate #2 | Desktop #2 |
| Microsoft #3 | Power #3 | Automate #3 | Desktop #3 |
| Microsoft #4 | Power #4 | Automate #4 | Desktop #4 |
| Microsoft #5 | Power #5 | Automate #5 | Desktop #5 |
| Microsoft #6 | Power #6 | Automate #6 | Desktop #6 |
| Microsoft #7 | Power #7 | Automate #7 | Desktop #7 |
| Microsoft #8 | Power #8 | Automate #8 | Desktop #8 |
| Microsoft #9 | Power #9 | Automate #9 | Desktop #9 |
| Microsoft #10 | Power #10 | Automate #10 | Desktop #10 |
Categories:
I have the same question (0)
All responses (
Answers (
