So you weren't able to connect your Google Sheets to Layer. Not to worry, there are two possible reasons why that might be happening that can be easily fixed:

  1. Connecting a spreadsheet with restricted sharing settings.

  2. Connecting a spreadsheet with restricted workspace settings.

Connecting a spreadsheet with restricted sharing settings

You can't connect a Google Sheet that is shared with you as a viewer. You need to either be the owner or an editor of the sheet. To fix this, you need to ask the spreadsheet owner for editing permissions.

Connecting a spreadsheet with restricted workspace settings

You can't connect a Google spreadsheet with restricted sharing settings set by an administrator for your Workspace, even if your Google account has access to the files.

However, a workspace administrator can easily fix this by enabling the sharing settings:

  1. From the Admin console Home page, go to Apps > Google Workspace > Drive and Docs.

  2. Click Sharing settings > Sharing options.

  3. For Sharing outside of your organization, click "On" and select the sharing options shown below.

  4. Click Save. If you configured an organizational unit or group, you might be able to inherit or override a parent organizational unit, or unset a group.

Please note that it can take up to 24 hours for changes to appear. During this time, older and newer settings might be intermittently enforced by Google.


Still having issues connecting your files?

Let us help you get started with Layer and start building your customized workflows today.

Schedule an onboarding call with Layer

Did this answer your question?