Integrating Google Sheets with Shortcuts can help streamline your workflow and automate repetitive tasks. Here are the steps to integrate Google Sheets with Shortcuts:
- First, open the Shortcuts app on your iOS device.
- Tap the “+” button to create a new shortcut, then tap “Add Action.”
- Search for the “Get Contents of URL” action and add it to the shortcut.
- Open a web browser and log in to your Google account. Go to Google Sheets and open the spreadsheet you want to integrate with Shortcuts.
- In the address bar of your browser, copy the URL of the spreadsheet.
- Go back to the Shortcuts app and paste the URL into the “URL” field of the “Get Contents of URL” action.
- Scroll down to the “Headers” section of the “Get Contents of URL” action and tap “Add new header.”
- In the “Name” field, enter “Authorization” (without quotes).
- In the “Value” field, enter “Bearer” followed by a space and your Google Sheets API key. To obtain an API key, go to the Google Cloud Console and create a new project, then enable the Google Sheets API and create credentials.
- Once you have entered your API key in the “Value” field, tap “Done.”
- Scroll down to the “Output” section of the “Get Contents of URL” action and tap “JSON.”
- In the JSON field, tap the “Dictionary” button, then tap “Add new dictionary item.”
- In the “Key” field, enter “values” (without quotes).
- In the “Value” field, tap the “Text” button and enter the name of the sheet and cell you want to retrieve data from. For example, if you want to retrieve data from cell A1 in Sheet1, enter “Sheet1!A1” (without quotes).
- Once you have entered the sheet and cell information, tap “Done.”
- Add any additional actions to the shortcut as needed, such as sending an email with the retrieved data or saving it to a file.
- Save the shortcut and give it a name.
- To run the shortcut, open the Shortcuts app and tap on the shortcut you created.
By following these steps, you can easily integrate Google Sheets with Shortcuts and automate your workflow. You can also modify the shortcut to perform other actions, such as updating data in the spreadsheet or adding new rows.