To share your Google Sheets data with others and collect input, you'll need to create connections. By creating a connection, Layer will create a new separate spreadsheet with the shared data and share it with the specified recipients.

Connections are newly created Google Sheets:

  • They sit in your Google Drive

  • They contain the parts of your main file (tabs and/or ranges) specified by you

  • They sync with your main file (i.e., when you change something in your main file, these changes will be reflected in the Connection)

  • And they can be accessed and edited by your collaborators (just like any other Google Sheet)

On top of specifying the data and collaborators (or recipients), you can define due dates and recurring tasks as part of the connection configuration.

Check out: How to create a connection?

Your collaborators can edit the connected files. Their changes would be sent to you (spreadsheet owner), and you can choose whether you want to accept them and merge them into the main spreadsheet or not.

For example, a CFO has their company budget spreadsheet on Google Sheets. He creates a connection consisting of the marketing budget sheet and shares it with the CMO. The connection also includes a recurring monthly task for the CMO to submit the updated marketing budget and metrics to be merged back into the main company budget.

Need help?

Let us show you how to make the most of Layer, as well as set up your connections and integrations.

Schedule an onboarding call with Layer
Did this answer your question?