What is the Google Sheets sharing feature?
While you work with Excel files on Layer, you can choose to share data as a downloadable Excel file or a link via Layer Sheets or Google Sheets.
Why share data via Google Sheets?
Sharing the data through Google Sheets has several advantages over sharing it as an Excel file:
Share data with people who prefer to work with Google Sheets.
Share data with people that don't have an Excel license.
Keep working in Excel while your team leverages the full power of working with Google Sheets.
How does it work?
To share data on Layer via Google Sheets:
Selecting a spreadsheet from the "My Spreadsheets" tab.
Click the "Share" button in the upper right corner.
In the "Access & Security Settings" section, check the "Google Sheets" box.
If you're sharing data via Google Sheets for the first time, Google will ask you to allow Layer to access your Google Drive.
Keep in mind that you can only share data via Google Sheets if the recipient's email address is connected to a Google account.
How can the recipient view and edit the file?
When you share data with someone, they receive an email with instructions on how to view and edit the spreadsheet via Google Sheets and submit changes.
The email will contain an "Open Layer" button.
Click the "Open Layer" button. This will display the shared flow.
Click the "Open As Google Sheet" button. This will display the shared data on Google Sheets.
Enter the requested data input.
Once you're done, head back to the Layer flow window.
You can submit an optional message if needed.
Toggle the "Attach data from Google Sheet" switch if you wish to submit your changes to the Excel file.
Even though the recipient can access a Layer page specially created to submit input, the recipient does not need a Layer account unless the "Require sign-in" option was check when creating the flow.
Once the recipient submits the data, you will get an email notification to review the changes.
Need help setting up your Flows?
Let us show you how to make the most of Layer and start building better workflows today.