Connect the Google Sheets Partner App
Copilot makes it simple to share Google Sheets with your clients directly within your portal. You can embed a view-only Google Sheet to display data to your clients, or an editable Google Sheet to collaborate with your clients as well.
Go to App Setup, and click + Add an app in the top right corner.
Click Add under Google Sheets. Set a title and icon that represents the app.
We recommend setting this up as a manual app so that you can embed different data for each client. If you want this app to be visible to all clients, set this as an automatic App.
Next, click Add. You will be taken to to the app's page, where you can set the embed for each client, group, or company.
Click Add to add your first embed or link. Select the client(s) or company to share the app with.
Select Show as embed so that the client isn't directed outside of the portal.
Next, go to your Google Sheets home page:
Find and open the desired document you want to embed. (You can also locate and open a Google Sheet within your Google Drive).
To share a Sheet, click Share, and under General Access, change it to Anyone With Link.
If you want clients to edit or only view the sheet, make sure to specify on the right.
Copy the link.
Go back to the App Setup page, paste the copied link into the content box and click Save.
To preview the app as a client, connect the app to your test client. Then, click Portal at the bottom of the sidebar and click Open portal. Once you're logged in as your test client you'll be able to view the connected app.