Troubleshoot Google Sheets errors in Workflow Builder
Troubleshoot Google Sheets errors in Workflow Builder
If you’re having trouble adding or using a Google Sheets workflow step, read on to learn more about what may be going wrong and how to troubleshoot.
Can't find the spreadsheet you need
If you can’t see the spreadsheet you want to use in the drop-down menu after adding a Google Sheets step, try the following steps to ensure that the right permissions are set:
From your in progress workflow, add a new Google Sheets step.
Next to your connected account, click Change, then click Change account.
From the authorisation prompt in your browser, ensure that See and download all your Google Drive files and See, edit, create and delete all your Google Sheets spreadsheets are ticked, then click Continue.
Return to Workflow Builder to continue creating your workflow.
If the spreadsheet you’ve selected for your step doesn’t include column names, you’ll see a We had a problem loading your spreadsheet error message. This happens because it’s not possible for Slack to send data to a spreadsheet without them. Here’s how to fix this issue:
Open your spreadsheet and add column names.
Return to Workflow Builder and select the step that you were editing.
Below the drop-down menus, you should see Columns and Value fields.
Incorrect permissions
If your workflow includes steps to send information to a spreadsheet with restricted permissions, you and the people using your workflow may receive error messages via a direct message (DM) from Slackbot. To fix the problem, you have two options:
Update spreadsheet permissions Open your spreadsheet and update the permissions so that the right people have access.
Switch your Google account If your spreadsheet needs to stay private or restricted to certain people, you can change the Google account used by the workflow to your own. Then, anyone who uses the workflow will be able to complete steps that send data to the spreadsheet via your account.
