{"id":11654,"date":"2023-03-12T10:31:24","date_gmt":"2023-03-12T07:01:24","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/scraping-data-from-amazon-into-google-sheets-using-scraperapi-and-google-apps-script-25k9\/"},"modified":"2023-03-12T10:31:24","modified_gmt":"2023-03-12T07:01:24","slug":"scraping-data-from-amazon-into-google-sheets-using-scraperapi-and-google-apps-script-25k9","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/scraping-data-from-amazon-into-google-sheets-using-scraperapi-and-google-apps-script-25k9\/","title":{"rendered":"\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 ScraperAPI \u0648 Google Apps Script \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u0622\u0645\u0627\u0632\u0648\u0646 \u062f\u0631 Google Sheets \u062e\u0631\u0627\u0634 \u062f\u0647\u06cc\u062f"},"content":{"rendered":"<div data-article-id=\"1397347\" id=\"article-body\">\n<h2>\n<p>  \u0627\u0628\u0632\u0627\u0631 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632<br \/>\n<\/h2>\n<ul>\n<li>Scraper API<\/li>\n<li>Google Sheets<\/li>\n<li>\u0627\u0633\u06a9\u0631\u06cc\u067e\u062a Google Apps<\/li>\n<\/ul>\n<p>\u0631\u0627\u0647\u0646\u0645\u0627<\/p>\n<ol>\n<li>\u0628\u0627 ScraperAPI \u062d\u0633\u0627\u0628 \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u06cc\u0627 \u0648\u0627\u0631\u062f \u0622\u0646 \u0634\u0648\u06cc\u062f.  \u0628\u0647 \u062f\u0627\u0634\u0628\u0648\u0631\u062f \u062e\u0648\u062f \u0628\u0631\u0648\u06cc\u062f \u0648 \u06a9\u0644\u06cc\u062f ScraperAPI API \u062e\u0648\u062f \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f.  \u0637\u0631\u062d \u0631\u0627\u06cc\u06af\u0627\u0646 ScraperAPI \u0628\u0647 \u0634\u0645\u0627 5000 \u062a\u0645\u0627\u0633 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0641\u062a \u0631\u0648\u0632 \u0627\u0648\u0644 \u062b\u0628\u062a \u0646\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f.  \u067e\u0633 \u0627\u0632 \u0622\u0646\u060c 1000 \u062a\u0645\u0627\u0633 \u062f\u0631 \u0637\u0631\u062d \u0631\u0627\u06cc\u06af\u0627\u0646 \u062e\u0648\u062f \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/li>\n<li>\u06cc\u06a9 \u0641\u0627\u06cc\u0644 Google Sheets \u062c\u062f\u06cc\u062f \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.  \u0646\u0627\u0645 \u0645\u0639\u062f\u0646: \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0631\u06af\u0647 \u0647\u0627\u06cc \u06af\u0648\u06af\u0644 \u0622\u0645\u0627\u0632\u0648\u0646.  \u0628\u0631\u0627\u06cc \u0631\u0627\u062d\u062a\u06cc \u0648 \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648 \u0628\u0627 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0645\u0646\u060c \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u0645 G-Sheets \u062e\u0648\u062f \u0631\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0637\u0631\u0627\u062d\u06cc \u06a9\u0646\u06cc\u062f.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0627\u06af\u0631 \u062a\u0631\u062c\u06cc\u062d \u0646\u0645\u06cc \u062f\u0647\u06cc\u062f\u060c \u0647\u0645\u06cc\u0634\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0646\u0638\u06cc\u0645\u0627\u062a\u06cc \u0631\u0627 \u062f\u0631 \u06a9\u062f \u062e\u0648\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0648\u0636\u0648\u062d\u060c \u0633\u0631\u0641\u0635\u0644 \u0647\u0627\u06cc \u0633\u062a\u0648\u0646 \u0645\u0627 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632: S\/N\u060c \u0634\u0646\u0627\u0633\u0647 \u0635\u0641\u062d\u0647\u060c \u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u0645\u062d\u0635\u0648\u0644\u060c URL \u0645\u062d\u0635\u0648\u0644\u060c \u062a\u0635\u0627\u0648\u06cc\u0631\u060c \u0631\u062a\u0628\u0647 \u0628\u0646\u062f\u06cc\u060c \u0646\u0638\u0631\u0627\u062a \u0648 \u0642\u06cc\u0645\u062a. <\/li>\n<li>\u0628\u0631\u0627\u06cc \u0633\u0647\u0648\u0644\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u060c \u06a9\u0644\u06cc\u062f \u062c\u0633\u062a\u062c\u0648 \u062f\u0631 \u0633\u0644\u0648\u0644 B2 \u0627\u0646\u062a\u0638\u0627\u0631 \u0645\u06cc \u0631\u0648\u062f.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0631\u0627 \u06a9\u062f\u06af\u0630\u0627\u0631\u06cc \u06a9\u0646\u06cc\u0645:\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>function mainFunction()    \n\/\/Attach this function to a trigger of sorts in your Google Sheets\n{\n    clearRecords();\n\n    var ss = SpreadsheetApp.getActiveSpreadsheet();\n    var tableSheet = ss.getSheetByName(\u2018TABLE\u2019);\n    var settingSheet = ss.getSheetByName(\u2018SETTINGS\u2019);\n    var searchValue = tableSheet.getRange(1,2).getValue();\n    var API_KEY = xxxxx;\n\n    var url = \u201chttp:\/\/api.scraperapi.com\u201d;\nurl += \u201c?api_key=\u201d+api_key\nurl += \u201c&amp;autoparse=true\u201d;\nurl += \u201c&amp;url=https:\/\/www.amazon.com\/s?k=\u201d+searchValue;\n\n\/\/ fetch data from API\nvar response = UrlFetchApp.fetch(url);\nvar json = response.getContentText();\nvar data = JSON.parse(json);\n\nvar item_count = 1;\n\nfor (var i = 0; i = data.results.length; i++)\n{\nvar results = data.results;\nvar name = results[i].name;\nvar image = results[i].image;\nvar list_url = results[i].url;\nvar stars = results[i].price;\nvar reviews = results[i].total_reviews;\n\nif (stars == null)\n{\n    stars = 0;\n}\n\nif(reviews == null)\n{\n    reviews = 0;\n}\n\naddRecord(item_count, 1, name, list_url, stars, reviews, price);\n\nitem_count+\n    }\n\n    var pages = data.pagination;\n\n    if(pages.length &gt; 0)\n{\n    for {var x = 0; x &lt; pages.length: x++)\n    {\n        Utilities.sleep(2000);\n\n        var url = \u201chttp:\/\/api.scraperapi.com\u201d;\nurl += \u201c?api_key=\u201d+api_key\nurl += \u201c&amp;autoparse=true\u201d;\nurl += \u201c&amp;url=\u201d+pages[x];\n\n\n       function clearRecords()\n       {\n    var ss= SpreadsheetApp.getActiveSpreadsheet();\n    var tableSheet = ss.getSheetByName(\u2018TABLE\u2019);\n    tableSheet.gtRange(\u2018A4:H1000\u2019).clear();\n       }\n\n     function addRecord(coun, page, name, image, list_url, stars, reviews, price){\n    var ss = SpreadsheetApp.getActiveSpreadsheet();\n    var tableSheet = ss.getSheetByName(\u2018TABLE\u2019);\n    tableSheet.appendRow([count, page, name, image, list_url, stars, reviews, price]);\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0628\u0632\u0627\u0631 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 Scraper API Google Sheets \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a Google Apps \u0631\u0627\u0647\u0646\u0645\u0627 \u0628\u0627 ScraperAPI \u062d\u0633\u0627\u0628 \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u06cc\u0627 \u0648\u0627\u0631\u062f \u0622\u0646 \u0634\u0648\u06cc\u062f. \u0628\u0647 \u062f\u0627\u0634\u0628\u0648\u0631\u062f \u062e\u0648\u062f \u0628\u0631\u0648\u06cc\u062f \u0648 \u06a9\u0644\u06cc\u062f ScraperAPI API \u062e\u0648\u062f \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0637\u0631\u062d \u0631\u0627\u06cc\u06af\u0627\u0646 ScraperAPI \u0628\u0647 \u0634\u0645\u0627 5000 \u062a\u0645\u0627\u0633 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0641\u062a \u0631\u0648\u0632 \u0627\u0648\u0644 \u062b\u0628\u062a \u0646\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f. \u067e\u0633 \u0627\u0632 \u0622\u0646\u060c 1000 \u062a\u0645\u0627\u0633 \u062f\u0631 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":11655,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-11654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/11654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=11654"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/11654\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/11655"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=11654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=11654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=11654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}