Comment intégrer Google Sheets dans Google Sites

Google Sites is a tool that allows you to follow the metrics of your business. At Google Site, you monitor the data from your Google sources: Google drive, Google Sheets, Google Slides, docs forms, etc. It stands to reason that if your business uses Google tools, then Google Sites is the perfect way for you and for the stakeholders to view your main metrics. Learn in this blog post how to embed Google Sheet into Google Site.

How to customize your Google Site?

Step 1: Select a corporate image

Firstly, choose a great corporate image in order to make your Google Site appealing (Orange circle). This is an example of a Human Resources department page on Google Sites:

Step 2: Embed sheets in Google site

Use the sidebar to manage your Google Site. You can add here sheets, embed anything, change the theme and page options, modify fonts and styles, etc. Within the section Gender by site, you are able to insert information directly from Google Sheets, using a very intuitive interface. Simply open the interface, select the tables or graphs you wish to insert, and you’re done. The steps are described below:

Finally, the result is:

Google data studio: the next level

We have already seen the features of Google Sites, but there is another tool for monitoring data – Google Data Studio. Google Data Studio is even more complete than Google Sites because you can import data from other sources like Google Analytics, Ads or MySQL. You can modify everything you can imagine, but it has a cost. Google Data Studio is really more complex to elaborate on. Check this example of Google Ads stats in Google Data Studio:

In this case, the way to connect your information is a bit different. When you open a new Data Studio you have to connect one data source (Google Sheet, MySQL, Google Analytics, etc) and configure it before adding new ones. After that, you can get data from other data sources and configure one each time.

How to import data from Google Sheets to Google Data Studio?

To connect a data source to Google Data Studio, you have to open the Insérer menu, click on Tableau, and drag the mouse over the page. You will automatically see Select data source on the sidebar. In this example, a google sheet is used.

When you choose a Google Sheet as a data source, you have to define dimensions and metrics (dimensions are the features with which you can classify the metrics). You can learn more about it on this Google page.

Google Sites or Google Data Studio

Google Sites and Google Data Studio provide us with a way to track and show our business’s most important metrics. Google Sites is simpler and lets you create a good report in a short amount of time. On the other hand, Google Data Studio allows you to track all kinds of metrics and make changes.