{"id":7950,"date":"2017-12-18T15:10:32","date_gmt":"2017-12-18T14:10:32","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7950"},"modified":"2017-12-18T15:10:32","modified_gmt":"2017-12-18T14:10:32","slug":"crear-macros-en-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/spreadsheets-tips\/structured-data-reporting-import-io-google-sheets\/","title":{"rendered":"Obtenir des donn\u00e9es structur\u00e9es pour la cr\u00e9ation de rapports dans Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][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

How to get structured data for reporting<\/h3>\n

Your company has decided to standardize spreadsheets and reporting on Google Sheets. That\u2019s great, but first, you need to get the data you want to report on. If that data resides on the web, then you can get structured data with data extraction.<\/p>\n

Data extraction is sometimes referred to as web scraping, but it\u2019s much more than that. All you need is one URL to get started.<\/p>\n

For this example, we want to report on Samsung product sentiment on Amazon.com.<\/p>\n

First:
we search on Amazon for Samsung products.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Amazon-image3-blog.webp” alt=”Search Results for Samsung in Amazon” title_text=”search-results” _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

Then copy and paste the resulting search URL into\u00a0<\/span>Import.io.<\/strong><\/a><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Extractor-image1-blog.webp” alt=”Import io Google Sheets: URL of Search Results Pasted to Import io” title_text=”url-to-import-io” 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

Since this is just the first page of products, Import.io can tell that more pages exist and gives you the option to add all of them.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Pagination-image4-blog.webp” alt=”Option to Adding All Result Pages” title_text=”add-all-pages-option” 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

After the data extraction process completes, Import.io allows you to select what data to extract into as many columns as you need.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Extractor-image5-blog.webp” alt=”Import io Google Sheets: Choosing Data to Extract into Columns” title_text=”extract-data-into-columns” 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

We only wanted the product name and rating info this time and we\u2019ll download those two columns to an Excel spreadsheet.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Dashboard-image6-blog.webp” alt=”Product Name and Rating Information in import-io” title_text=”import-io-with-data” 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

Now, you have a great spreadsheet of customer sentiment data to the format and integrate into your Google Sheets database using\u00a0<\/span>Sheetgo<\/a>. Read through the simple steps in this blog post on how to easily\u00a0<\/span>upload Excel to Google Sheets<\/a>.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Excel-image6-blog.png” alt=”Product Name and Rating Info in Excel File” title_text=”extracted-data-in-excel” 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

Since customer sentiment continuously changes, you can schedule this to run every day or even every hour. Import.io also provides an optional hourly, daily, or weekly report on just what has changed to make it easier to update your reports. So, once you run this extraction, you are set to receive the latest data for tracking sentiment ongoing.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/Change-report-image2-blog.webp” alt=”Import io Google Sheets: Snapshot of Schedule Options for Update Reports” title_text=”schedule-options” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

How to get structured data for reporting Your company has decided to standardize spreadsheets and reporting on Google Sheets. That\u2019s great, but first, you need to get the data you want to report on. If that data resides on the web, then you can get structured data with data extraction. Data extraction is sometimes referred […]<\/p>\n","protected":false},"author":2,"featured_media":8020,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"

How to get Structured Data for Reporting<\/h1>\nYour company has decided to standardize spreadsheets and reporting on Google Sheets. That\u2019s great, but first you need to get the data you want to report on. If that data resides on the web, then you can get structured data with data extraction.\n\nData extraction is sometimes referred to as web scraping, but it\u2019s much more than that. All you need is one URL to get started.\n\nFor this example, we want to report on Samsung product sentiment on Amazon.com.\n\nFirst:\nwe search on Amazon for Samsung products.\n\n\"\"\n\nThen copy and paste the resulting search URL into Import.io.<\/strong><\/a>\n\n\"\"Since this is just the first page of products, Import.io can tell that more pages exist and gives you the option to add all of them.\n\n\"\"After the data extraction process completes, Import.io allows you to select what data to extract into as many columns as you need.\n\n\"\"\n\nWe only wanted the product name and ratings info this time and we\u2019ll download those two columns to an Excel spreadsheet.\n\n\"\"\n\nNow, you have a great spreadsheet of customer sentiment data to the format and integrate into your Google Sheets database using Sheetgo<\/strong>.\n\n\"\"Since customer sentiment continuously changes, you can schedule this to run every day or even every hour. Import.io also provides an optional hourly, daily, or weekly report on just what has changed to make it easier to update your reports. So, once you run this extraction, you are set to receive the latest data for tracking sentiment ongoing.\n\n\"\"\n\n\u00a0\n\n\u00a0\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[29],"tags":[28],"class_list":["post-7950","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets-tips","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=7950"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7950\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8020"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=7950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=7950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=7950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}