{"id":3878,"date":"2025-05-22T16:07:09","date_gmt":"2025-05-22T14:07:09","guid":{"rendered":"https:\/\/iconsult.agency\/blog\/?p=3878"},"modified":"2025-05-22T16:07:09","modified_gmt":"2025-05-22T14:07:09","slug":"automated-measurement-of-web-vitals-using-a-google-spreadsheet","status":"publish","type":"post","link":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/","title":{"rendered":"Automated measurement of Web Vitals using a Google spreadsheet"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg\" data-width=\"1024\" data-height=\"576\" src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg\" alt=\"\" class=\"wp-image-3876\" srcset=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg 1024w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-300x169.jpg 300w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-768x432.jpg 768w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1536x863.jpg 1536w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123.jpg 1955w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<h2 class=\"wp-block-heading\" id=\"\u043a\u0430\u043a-\u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e-\u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0442\u044c-\u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435-\u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432-\u0441\u043a\u043e\u0440\u043e\u0441\u0442\u0438-\u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438-\u0441\u0442\u0440\u0430\u043d\u0438\u0446-\">How to track changes in page load speed parameters for free?<\/h2>\n\n<p>While there are quite a few tools out there to help you measure basic website vitals - from <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/web-vitals\/ahfhijdlegdabablpippeagghigmibma?hl=en\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Chrome extensions<\/a> to <a href=\"https:\/\/web.dev\/measure\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">web apps<\/a> - they run manually and only measure basic vitals for one site at a time.<br><br>If you want to automatically measure basic web metrics for multiple sites, such as you and your competitors, use this <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1GUDpdBMT26uwcIYCbDjKH9hPAnkcqMfJOuAICZ9Yn_Y\/edit\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google<\/a> spreadsheet.<br><br>Not only will it help you measure metrics for multiple URLs, but it will also help you visualize the change in metrics using sparclines.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"gutentoc tocactive nostyle\"><div class=\"gutentoc-toc-wrap\"><div class=\"gutentoc-toc-title-wrap\"><div class=\"gutentoc-toc-title\"><h2>Table of Contents<\/h2><\/div><div id=\"open\" class=\"toggletwo\">show<\/div><\/div><div id=\"toclist\"><div class=\"gutentoc-toc__list-wrap\"><ul class=\"gutentoc-toc__list\"><li><a href=\"#\u043a\u0430\u043a-\u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e-\u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0442\u044c-\u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435-\u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432-\u0441\u043a\u043e\u0440\u043e\u0441\u0442\u0438-\u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438-\u0441\u0442\u0440\u0430\u043d\u0438\u0446-\">How to track changes in page load speed parameters for free? <\/a><\/li><li><a href=\"#\u043a\u0430\u043a-\u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c-\u0442\u0430\u0431\u043b\u0438\u0446\u0443-\u043f\u043e\u0434-\u0441\u0432\u043e\u0438-\u043f\u0440\u043e\u0435\u043a\u0442\u044b\">How to customize the table for your projects<\/a><\/li><li><a href=\"#\u043f\u043e\u0445\u043e\u0436\u0438\u0435-\u0441\u0442\u0430\u0442\u044c\u0438-\">Related articles <\/a><\/li><\/ul><\/div><\/div><\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1280\" height=\"711\" data-src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1.jpg\" data-width=\"1280\" data-height=\"711\" src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1.jpg\" alt=\"Table with the results of Web Vitals parameter measurements\" class=\"wp-image-3877\" srcset=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1.jpg 1280w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1-300x167.jpg 300w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1-1024x569.jpg 1024w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/12-1-768x427.jpg 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><figcaption class=\"wp-element-caption\">Table with the results of Web Vitals parameter measurements<\/figcaption><\/figure>\n\n\n<h2 class=\"wp-block-heading\" id=\"\u043a\u0430\u043a-\u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c-\u0442\u0430\u0431\u043b\u0438\u0446\u0443-\u043f\u043e\u0434-\u0441\u0432\u043e\u0438-\u043f\u0440\u043e\u0435\u043a\u0442\u044b\">How to customize the table for your projects<\/h2>\n\n\n<ol class=\"wp-block-list\">\n<li>Make a copy of the <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1GUDpdBMT26uwcIYCbDjKH9hPAnkcqMfJOuAICZ9Yn_Y\/copy\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Web Vitals<\/a> table in your Google Drive.<\/li>\n\n\n\n<li>Click the first tab and enter a list of URLs that you want to measure and track. Also specify unique sheet names for each URL, and the metrics for that URL will be saved on the corresponding sheet.<\/li>\n\n\n\n<li>Click the \"Track Web Vitals\" button, authorize the sheet, and you're done.<\/li>\n<\/ol>\n\n\n<p class=\"has-normal-font-size\">The button will set up a daily cron job, a program that runs scheduled tasks. It will automatically connect to the Google PageSpeed API, extract the main vital signs for each specified URL and record them in the corresponding sheet.<\/p>\n\n\n<p class=\"has-normal-font-size\"><a href=\"https:\/\/github.com\/labnol\/code\/tree\/master\/google-apps-script\/core-vitals\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">The source code of the<\/a> application script is available on Github. You can reuse, modify and publish the code according to your own requirements.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"485\" data-src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/image.png\" data-width=\"720\" data-height=\"485\" src=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/image.png\" alt=\"\" class=\"wp-image-3875\" srcset=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/image.png 720w, https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/image-300x202.png 300w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n<p>These metrics are measured for the desktop and mobile version of the site:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First Contentful Paint<\/li>\n\n\n\n<li>First Input Delay<\/li>\n\n\n\n<li>Largest Contentful Paint<\/li>\n\n\n\n<li>Cumulative Layout Shift<\/li>\n\n\n\n<li>Speed Index<\/li>\n\n\n\n<li>Time to Interactive<\/li>\n\n\n\n<li>Estimated Input Latency <\/li>\n<\/ul>\n\n\n<p><a href=\"https:\/\/www.labnol.org\/core-web-vitals-200819\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" aria-label=\"\u041f\u0435\u0440\u0432\u043e\u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a (\u043e\u0442\u043a\u0440\u043e\u0435\u0442\u0441\u044f \u0432 \u043d\u043e\u0432\u043e\u0439 \u0432\u043a\u043b\u0430\u0434\u043a\u0435)\">Original source<\/a><\/p>\n\n\n<h2 class=\"wp-block-heading\" id=\"\u043f\u043e\u0445\u043e\u0436\u0438\u0435-\u0441\u0442\u0430\u0442\u044c\u0438-\">Related Articles<\/h2>\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/iconsult.agency\/blog\/seo-kopirayting-i-lsi-kak-optimizirovat-statyu\/\" target=\"_blank\" rel=\"noreferrer noopener\">SEO-copywriting and LSI: how to optimize an article to please search engines<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/iconsult.agency\/blog\/kak-sozdat-strukturu-sayta-na-osnove-semanticheskogo-yadra\/\" target=\"_blank\" rel=\"noreferrer noopener\">Creating a site structure based on the semantic kernel: instructions<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/iconsult.agency\/blog\/tehnika-lavinnogo-seo-ranzhirovanie-bez-resursov-perevod-stati-avalanche-seo-technique\/\" target=\"_blank\" rel=\"noreferrer noopener\">Avalanche SEO Technique - Ranking without resources<\/a> <\/li>\n\n\n\n<li><a aria-label=\" (\u043e\u0442\u043a\u0440\u043e\u0435\u0442\u0441\u044f \u0432 \u043d\u043e\u0432\u043e\u0439 \u0432\u043a\u043b\u0430\u0434\u043a\u0435)\" href=\"https:\/\/iconsult.agency\/blog\/kak-predostavit-dostup-k-google-analytics-ga\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to grant access to Google Analytics (GA)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to track changes in page load speed parameters for free? While there are quite a few tools out there to help you measure basic website vitals &#8212; from Chrome extensions to web apps &#8212; they run manually and only measure basic vitals for one site at a time. If you want to automatically measure [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[473,482],"tags":[],"class_list":["post-3878","post","type-post","status-publish","format-standard","hentry","category-instructions","category-seo"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency<\/title>\n<meta name=\"description\" content=\"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency\" \/>\n<meta property=\"og:description\" content=\"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/iConsult.Agency\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-22T14:07:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg\" \/>\n<meta name=\"author\" content=\"Alexey Grishin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexey Grishin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\"},\"author\":{\"name\":\"Alexey Grishin\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/f6d66ca1175fa8acd587baed61a7b3df\"},\"headline\":\"Automated measurement of Web Vitals using a Google spreadsheet\",\"datePublished\":\"2025-05-22T14:07:09+00:00\",\"dateModified\":\"2025-05-22T14:07:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\"},\"wordCount\":346,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg\",\"articleSection\":[\"Instructions.\",\"SEO\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\",\"url\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\",\"name\":\"Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency\",\"isPartOf\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg\",\"datePublished\":\"2025-05-22T14:07:09+00:00\",\"dateModified\":\"2025-05-22T14:07:09+00:00\",\"description\":\"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.\",\"breadcrumb\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage\",\"url\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123.jpg\",\"contentUrl\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123.jpg\",\"width\":1955,\"height\":1099},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\/\/iconsult.agency\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automated measurement of Web Vitals using a Google spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#website\",\"url\":\"https:\/\/iconsult.agency\/blog\/\",\"name\":\"\u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency\",\"description\":\"\u0411\u043b\u043e\u0433 \u043e \u043f\u0440\u043e\u0434\u0432\u0438\u0436\u0435\u043d\u0438\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 (SEO) \u0438 \u0432\u0435\u0431-\u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0435\",\"publisher\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iconsult.agency\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#organization\",\"name\":\"iConsult Agency\",\"url\":\"https:\/\/iconsult.agency\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/logo_dark.png\",\"contentUrl\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/logo_dark.png\",\"width\":100,\"height\":62,\"caption\":\"iConsult Agency\"},\"image\":{\"@id\":\"https:\/\/iconsult.agency\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/iConsult.Agency\/\",\"https:\/\/www.instagram.com\/_iconsult_\/\",\"https:\/\/www.linkedin.com\/company\/iconsult-agency\/\",\"https:\/\/www.youtube.com\/channel\/UCZeb3oR03SIY5uJc0EJ6guA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/f6d66ca1175fa8acd587baed61a7b3df\",\"name\":\"Alexey Grishin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/LEON6684.png\",\"contentUrl\":\"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/LEON6684.png\",\"caption\":\"Alexey Grishin\"},\"url\":\"https:\/\/iconsult.agency\/blog\/author\/alexey\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency","description":"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/","og_locale":"ru_RU","og_type":"article","og_title":"Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency","og_description":"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.","og_url":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/","og_site_name":"\u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency","article_publisher":"https:\/\/www.facebook.com\/iConsult.Agency\/","article_published_time":"2025-05-22T14:07:09+00:00","og_image":[{"url":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg"}],"author":"Alexey Grishin","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"Alexey Grishin","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"2 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/"},"author":{"name":"Alexey Grishin","@id":"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/f6d66ca1175fa8acd587baed61a7b3df"},"headline":"Automated measurement of Web Vitals using a Google spreadsheet","datePublished":"2025-05-22T14:07:09+00:00","dateModified":"2025-05-22T14:07:09+00:00","mainEntityOfPage":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/"},"wordCount":346,"commentCount":10,"publisher":{"@id":"https:\/\/iconsult.agency\/blog\/#organization"},"image":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg","articleSection":["Instructions.","SEO"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/","url":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/","name":"Automated measurement of Web Vitals using a Google spreadsheet - \u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency","isPartOf":{"@id":"https:\/\/iconsult.agency\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123-1024x576.jpg","datePublished":"2025-05-22T14:07:09+00:00","dateModified":"2025-05-22T14:07:09+00:00","description":"How to measure page load speed for free and regularly? Collecting data about yourself and your competitors: instructions for setting up a Google table.","breadcrumb":{"@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#primaryimage","url":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123.jpg","contentUrl":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/12\/123.jpg","width":1955,"height":1099},{"@type":"BreadcrumbList","@id":"https:\/\/iconsult.agency\/blog\/en\/automated-measurement-of-web-vitals-using-a-google-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/iconsult.agency\/blog\/"},{"@type":"ListItem","position":2,"name":"Automated measurement of Web Vitals using a Google spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/iconsult.agency\/blog\/#website","url":"https:\/\/iconsult.agency\/blog\/","name":"\u0411\u043b\u043e\u0433 \u043e\u0431 \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0435 - iConsult Agency","description":"\u0411\u043b\u043e\u0433 \u043e \u043f\u0440\u043e\u0434\u0432\u0438\u0436\u0435\u043d\u0438\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 (SEO) \u0438 \u0432\u0435\u0431-\u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0435","publisher":{"@id":"https:\/\/iconsult.agency\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iconsult.agency\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/iconsult.agency\/blog\/#organization","name":"iConsult Agency","url":"https:\/\/iconsult.agency\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/iconsult.agency\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/logo_dark.png","contentUrl":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/logo_dark.png","width":100,"height":62,"caption":"iConsult Agency"},"image":{"@id":"https:\/\/iconsult.agency\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/iConsult.Agency\/","https:\/\/www.instagram.com\/_iconsult_\/","https:\/\/www.linkedin.com\/company\/iconsult-agency\/","https:\/\/www.youtube.com\/channel\/UCZeb3oR03SIY5uJc0EJ6guA"]},{"@type":"Person","@id":"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/f6d66ca1175fa8acd587baed61a7b3df","name":"Alexey Grishin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/iconsult.agency\/blog\/#\/schema\/person\/image\/","url":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/LEON6684.png","contentUrl":"https:\/\/iconsult.agency\/blog\/wp-content\/uploads\/2020\/03\/LEON6684.png","caption":"Alexey Grishin"},"url":"https:\/\/iconsult.agency\/blog\/author\/alexey\/"}]}},"lang":"en","translations":{"en":3878,"ru":77,"uk":1826},"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/posts\/3878"}],"collection":[{"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/comments?post=3878"}],"version-history":[{"count":1,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/posts\/3878\/revisions"}],"predecessor-version":[{"id":3879,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/posts\/3878\/revisions\/3879"}],"wp:attachment":[{"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/media?parent=3878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/categories?post=3878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iconsult.agency\/blog\/wp-json\/wp\/v2\/tags?post=3878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}