## Google Sheets

Connect a spreadsheet from Google Sheets with view-only or edit permissions for your clients.

### Type
Embed

Assembly supports embedding any external application that doesn’t block embedding.

### App Visibility
Client

Client-facing apps are visible to clients as well as your internal team.

### Pricing
Free

### 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**  
1. Go to _App Library_, and click _\+ Add an app_ in the top right corner.  
2. Select _Google Sheets_ in the _Client-facing_ section.  
3. After clicking on the app, click on _Install_ in the top-right.  
4. Set a title and icon that represents the app.  
5. 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.  
6. Next, click _Add_. You will be taken to the app's page, where you can set the embed for each client, group, or company.  
7. Click _Add_ to add your first embed or link. Select the client(s) or company to share the app with.  
8. Select _Show as embed_ so that the client isn't directed outside of the portal.  
9. 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**   
1. Go to _App Library_, and click _\+ Add an app_ in the top right corner.  
2. Select _Google Sheets_ in the _Client-facing_ section.  
3. After clicking on the app, click on _Install_ in the top-right.  
4. 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.  
5. Select _Show as embed_ so that the client isn't directed outside of the portal.  
6. Next, go to your Google Sheets home page:  
7. Find and open the desired sheet you want to embed. (You can also locate and open a Google Sheet within your Google Drive)  
8. To share a Sheet, click _File > Share > Publish_ to Web and click _Publish_ on the _Link_ tab.  
9. 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**"

Your clients deserve better.

Try for free for 14 days, no credit card required.