{"id":2461,"date":"2017-02-16T06:08:06","date_gmt":"2017-02-16T09:08:06","guid":{"rendered":"https:\/\/importsheet.com\/?p=2461"},"modified":"2025-10-09T15:40:12","modified_gmt":"2025-10-09T13:40:12","slug":"incorporar-planilhas-do-google-sites","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/spreadsheets-tips\/embed-google-sites-sheets\/","title":{"rendered":"Como incorporar o Planilhas Google no Google Sites"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”||0px|||” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

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.<\/p>\n

How to customize your Google Site?<\/h3>\n

Step 1: Select a corporate image<\/h4>\n

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:<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/embed-google-sheet-into-google-site-1.png” alt=”embed google sheet into google site 1″ title_text=”embed google sheet into google site 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Step 2: Embed sheets in Google site<\/span><\/h4>\n

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<\/strong>, 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\u2019re done. The steps are described below: <\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/embed-google-sheet-into-google-site-2.png” alt=”embed google sheet into google site 2″ title_text=”embed google sheet into google site 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Finally, the result is:<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/embed-google-sheet-into-google-site-3.png” alt=”embed google sheet into google site 3″ title_text=”embed google sheet into google site 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Google data studio: the next level<\/h3>\n

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:<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/07\/11-750×331.png” alt=”Example of Google Ads Stats in Google Data Studio” title_text=”google-data-studio” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

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.<\/p>\n

How to import data from Google Sheets to Google Data Studio?<\/h3>\n

To connect a data source to Google Data Studio, you have to open the Insert<\/strong> menu, click on Table<\/strong>, and drag the mouse over the page. You will automatically see Select data source<\/strong> on the sidebar. In this example, a google sheet is used.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/07\/table-750×204.jpg” alt=”Embed Google Sheet Into Google Site: Connect a Data Source” title_text=”connect-data-source” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/02\/google-data-studio.webp” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]Next, you have to select Create a new data source<\/strong> at the bottom of the sidebar. Click on Google Sheets<\/strong> and choose the spreadsheet that you want to import data. After that, click on Add to report<\/strong>.<\/p>\n

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\u00a0<\/span>Google<\/a>\u00a0page.<\/p>\n

Google Sites or Google Data Studio<\/h3>\n

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.[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":10873,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sites is a tool that allows you\u00a0to follow the metrics of your business. At\u00a0Google Site you monitor the\u00a0data 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\u00a0and for the stakeholders to view your main metrics.\n\n\u00a0\n

Customizing your Google Site<\/h3>\nFirstly, choose a great corporate image in order to make your Google Site appealing (Orange circle)\n\nThis is an example of a Human Resources department page on Google Sites:\n\n\u00a0\n\n\"Google\n\n\u00a0\n\nUse the sidebar to manage your Google Site, adding sheets, embedding anything, changing the Theme and Page options, and modifying fonts and styles etc.\n\n\u00a0\n\nWithin the section 'Gender by site' tables and graphs you are able to\u00a0insert 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:\n\n\u00a0\n\n\"Google\n\n\u00a0\n\nFinally, the result is:\n\n\"Google\n\n\u00a0\n

Google data studio: the next level<\/h3>\n\u00a0\n\nWe have already seen the features of Google Sites, but there is another tool for monitoring data: Google Data Studio. This is even more complete than Google Sites because of you can import data from other sources like google analytics, adwords or MySQL. You can modify everything you can imagine. But this has a cost: it is really more complex to elaborate.<\/span>\n\n\u00a0\n\nCheck this example of Google AdWords stats in Google Data Studio:<\/span>\n\n\u00a0\n\n\"Google\n\n\u00a0\n\nIn this case, the way to connect your information\u00a0is a bit different. When you open a new Data Studio you have to connect one data source (Google Sheet, MySQL, Google Analytics, etc) then configure it before adding new ones.\u00a0<\/span>After that, you can get data from another data sources and configure one each time.<\/span>\n\n\u00a0\n

Import data from google sheets to google data studio<\/h4>\nTo connect a\u00a0data source to Google Data Studio, in this example a google sheet, you have to open insert menu, click on table and drag the mouse over the page. You will automatically see \"Select data source\" on the sidebar.<\/span>\n\n\u00a0\n\n\"Google\n\n\u00a0\n\n\u00a0\n\n\"Google\n\n\u00a0\n\nThen, you have to click on \u201cCreate a new data source\u201d at the bottom of the sidebar, click on google sheets and select the spreadsheet that you want import data. After that click on Add to report<\/span>\n\n\"Google\n\n\u00a0\n\nWhen you choose a google sheet as a data source you have to define dimensions and metrics (dimensions are\u00a0the features with which you can classify the metrics). You can know more about it in this google<\/a>\u00a0page.<\/span>\n\n\u00a0\n

Google Sites or Google Data Studio<\/h3>\n\u00a0\n\nGoogle Sites and Google Data Studio provide us with a way to follow and show the most important metrics of our business. Sites is simpler and in little time you can create a good report. On the other hand, in Google Data Studio you can follow all kinds of metrics and carry out changes.<\/span>\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[29],"tags":[28],"class_list":["post-2461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets-tips","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=2461"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2461\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/10873"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}