## Google Sheets Embed

Connect the Google Sheets Embed

### Overview

Assembly 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.

### **App Setup**

#### **Connecting Editable Google Sheets**

01. Go to _App Library_, and click _\+ Add an app_ in the top right corner.
02. Select _Google Sheets_ in the _Client-facing_ section.
03. After clicking on the app, click on _Install_ in the top-right.
04. Set a title and icon that represents the app.
05. We recommend setting this up as a **manual** app so that only the clients connected to the Google Sheets app can edit. If you want all clients to be able to edit the document, set this as an **automatic** app.
06. Next, click _Add_. You will be taken to the app's page, where you can set the embed for each client, group, or company.
07. Click _Add_ to add your first embed or link. Select the client(s) or company to share the app with.
08. Select _Show as embed_ so that the client isn't directed outside of the portal.
09. Next, go to your Google Sheets home page:
10. Find and open the desired document you want to embed. (You can also locate and open a Google Sheets within your Google Drive).
11. To share a Document, click _Share_ in the top-right of the Google Sheets and set the permissions to _Anyone with the link can edit._
12. Now copy the link and paste it into an empty text editor (you will need this link in a moment).
13. Next, copy the following code and paste this into your text editor below the link:

`<iframe src="link" />`

14. Lastly, paste the link copied from Google into the code where it says _link_. Be sure to keep the quotation marks around the Google Doc link.
15. Go back to the _App Setup_ page and paste the

`<iframe src="link" />`

(with the link replaced) into the content box and click _Add._

#### **Connecting View-Only Google Sheets**

01. Go to _App Library_, and click _\+ Add an app_ in the top right corner.
02. Select _Google Sheets_ in the _Client-facing_ section.
03. After clicking on the app, click on _Install_ in the top-right.
04. We recommend setting this up as an **automatic** App so that we can embed the same sheet for every client. If you want a specific sheet for each client, set this as a **manual** App.
05. Select _Show as embed_ so that the client isn't directed outside of the portal.
06. Next, go to your Google Sheets home page:
07. Find and open the desired sheet you want to embed. (You can also locate and open a Google Sheet within your Google Drive)
08. To share a Sheet, click _File > Share > Publish_ to Web and click _Publish_ on the _Link_ tab.
09. Copy the link.
10. Return to the _App Setup_ page, paste the copied link into the content box, and click _Add._

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.

#### Additional configuration

It is possible to remove the Google Sheets header and formatting bar by adding the attribute **&rm=minimal** to the Google Sheets link.

For example, if your share link is:

"https://docs.google.com/spreadsheets/d/1JoFk70ySJIRcYaLWP8LtF6aiQ3hoDTgmqjp0QkZ5-oE/edit?usp=sharing"

You would update it to the following to remove the extra headers:

"https://docs.google.com/spreadsheets/d/1JoFk70ySJIRcYaLWP8LtF6aiQ3hoDTgmqjp0QkZ5-oE/edit?usp=sharing **&rm=minimal**"

2. [Overview](/content/guide/google-sheets-partner-app#overview/index.html)  
3. [App Setup](/content/guide/google-sheets-partner-app#app-setup/index.html)  
4. [Connecting Editable Google Sheets](/content/guide/google-sheets-partner-app#app-setup-connecting-editable-google-sheets/index.html)  
5. [Connecting View-Only Google Sheets](/content/guide/google-sheets-partner-app#app-setup-connecting-view-only-google-sheets/index.html)  
6. [Additional configuration](/content/guide/google-sheets-partner-app#app-setup-additional-configuration/index.html)