Read Google Sheets API With Power Automate for Desktop

This example uses Invoke Web Service flow action to send a request to Google Sheets API, the response contains spreadsheet values.
How it works

This example uses Invoke Web Service flow action with Google API key parameter to send a request to Google Sheets API, the response contains spreadsheet values (Sheet1 A1:B1 in this example).

To be able to read Google Sheets you must:

  1. Create a API key
  2. Enable Google Sheets API
  3. Share the spreadsheet link with option Anyone with the link (not same as Publish to web)
How to create API key and enable Google Sheets API
Instructions
  • To be able to use API key, you must share the spreadsheet link using option Anyone with the link, see image
  • Line 1: Set Google API key
  • Line 2: Set Spreadsheet Id.
    ⠀⠀If you don’t know how to locate this, open your Google spreadheet and get it from the url:
    ⠀⠀https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0
  • Line 4: Replace Sheet1!A1:B1 with with the sheet and cell values you would like to read.
  • Line 5: The response is stored in ResponseObj
Notes
  • Do not expose your API key to anyone. Set API key restrictions to prevent unauthorized use and quota theft.
[1]https://developers.google.com/sheets/api/guides/concepts
[2]https://developers.google.com/sheets/api/guides/authorizing
[3]https://developers.google.com/sheets/api/samples
[4]https://cloud.google.com/docs/authentication/api-keys
PAG Admin
Flow Variables
Flow Datatypes
Also See These Flows
Flow Action
Schedule Flows Using Power Automate for Desktop

Did you know that the free edition of Power Automate Desktop does not include flow scheduling? Use this template to schedule flows.

PAG Admin

7,242

Flow Action
Making Microsoft Dataverse OAuth 2.0 Queries Using PAD

This example shows how to retrieve top 3 accounts from your Dataverse / Dynamics 365 environment using Power Automate Desktop.

PAG Admin

973

Flow Action
Create Animated Doughnut in Notepad

This example shows how to read JSON data, loop items and print output to screen (Notepad in this case).

PAG Admin

232

Flow Action
Open or Close an Application When Bluetooth Device Is Connected/Disconnected

This example opens and closes Spotify automatically when Bose NC 700 HP headphones are turned on/off. Discover how you can use Bluetooth as a trigger with Power Automate for Desktop. You can use any Bluetooth device and application.

PAG Admin

318

Flow Action
Run Flow From Command Prompt or Windows Task Scheduler

A simple way to run flows from Command Line, Windows Task Scheduler, shortcut keys or by using a URL.

PAG Admin

4,391