Using Google Sheets in Clinked

This article will explain how to insert a Google Sheet as an iFrame in Clinked 

Introduction

Google Sheets has been a key data tool for many businesses. It is also an efficient way to present data to your clients - and allows for iframes so you can integrate data views into your Clinked groups. This integration allows you to setup notes for others (even those without a Google account) to work directly in the Google Sheet from Clinked and update the changed made in real time in both Google and Clinked.

Step 1: How to create a Google Sheet

This section will explain how to create a Google Sheet, copy the url link and use the allowed domains in Clinked correctly.

  • Create your Google Sheet (to do this navigate to docs.google.com>spreadsheets). Start a new spreadsheet and select a template.
  • Once you have edited the spreadsheet and want to bring it into Clinked, click on the green ‘share’ button at the top right-hand corner of the Google Sheet. 

Image_A.png

  • Next press ‘Get Shareable Link’

Image_B_.png

 

Note: If preferred, a Google Sheet can be shared as a published read only document. To do this, hit File > Publish to the Web to get to the publish settings. Use the Link option and setup the appropriate page to be shared (i.e. workbook, 1 page, etc) and copy URL to use in iFrame instead. See below example:

image_c.png

Image_D.png

 

Now navigate to your Clinked account

You will need to place part of the Google Sheet url link into Clinked in the 'Allowed domains for iframe links' section before creating the note. 

  • Go into Account Settings> Security and Authentication> Allowed domains for iframe links  
  • Make sure that docs.google.com is an allowed domain. Type docs.google.com into the allowed domain for iframe links box and press update.

image_g_.png

 

Step 2: How to import a Google Sheet into a note

This section will explain the steps required to create the iframe using the notes functionality. Make sure the allowed domains have been set correctly beforehand. 

  • Firstly, navigate to the notes section and create a new note using the '+ new note' button 
  • Then press Insert > Embed iframe

Screenshot_2020-08-14_at_14.29.58.png

  • Paste the URL link from Google Sheets in the URL box. Adjust the width and height as required. Select insert to activate iframe.

image_h_.png

  • Your iFrame will appear as pictured below. Enter a note name and save your iframe.
  • You will be able to edit the Google Sheet directly from the Clinked note

image_i_.png

 

 Step 3: How to share the iframe on the Group Home Dashboard

This section will explain how to display a completed Google Sheet in a Group Homepage. 

  • Once you've setup your Google Sheet as a note in Clinked, you can also display it in the group homepage thanks to our widget functionality.
  • To do this: Press Add Widget> + Note

Screenshot_2020-05-22_at_13.03.17.png

  • Next you will need to configure the widget (the configure button is the cog on the right) Screenshot_2020-08-21_at_11.31.05.png
  • Then select the desired note you wish to display e.g. May Electricity Invoice 

image_j_.png

  • The note will appear on the homepage as pictured below, where it can be directly edited 

image_z.png

 

Hope this helps explain how you can work with Google Sheets in Clinked. Please see related articles below:

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.