Once you've created and shared a connection, you might see a "Review" label shown on your connection in the Layer add-on, indicating that a collaborator submitted data input and requested a review.

As the spreadsheet owner, you can then go through the changes and select which ones to merge back into the main spreadsheet and which to ignore.

To review data input:

  1. Select a connection with a pending review request (showing the "Review" label).

  2. The new input will be listed under "Changes". Here, you can see which cells were affected, grouped by their respective sheets.

  3. Clicking on a change will expand it so that you can view the cell's previous and updated values as well. In this example, the value of cell B5 changed from €2,000.00 to €2,500.00.

  4. You can select the data changes separately by checking the box next to each and selecting whether to accept or reject them. Alternatively, you can select all the changes per sheet by checking the box next to the sheet name (i.e. FP&A or Marketing Budget in this case).

  5. By clicking accept, selected changes will be merged into your main spreadsheet.

What is considered a change or input?

Only cell values and formula changes are considered changes and will be merged into your main spreadsheet if accepted. Added or changed cell stylings, formats, colors, added or removed sheets, and any other changes made by the collaborator will be ignored to keep your underlying spreadsheet's integrity.

What happens after I review the data?

If you review and accept data changes:

  • The accepted changes will overwrite your current data in the main spreadsheet.

  • A new version will be created by the Google Sheets version history feature, which you can restore or download at any time.

  • The collaborators will receive an email informing them that their data input has been reviewed.

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?