{"id":324,"date":"2025-03-13T10:49:19","date_gmt":"2025-03-13T10:49:19","guid":{"rendered":"https:\/\/documentation.iqonic.design\/graphina\/?p=324"},"modified":"2025-03-13T10:49:21","modified_gmt":"2025-03-13T10:49:21","slug":"how-to-fetch-dynamic-data-from-google-sheets-for-wordpress-charts","status":"publish","type":"post","link":"https:\/\/documentation.iqonic.design\/graphina\/how-to-fetch-dynamic-data-from-google-sheets-for-wordpress-charts\/","title":{"rendered":"How to Fetch Dynamic Data from Google Sheets for WordPress Charts"},"content":{"rendered":"<div class=\"nolwrap\">\n<h4 class=\"wp-block-heading\"><strong>Introduction<\/strong><\/h4>\n\n\n\n<p>Google Sheets offers various charting options, but if you want to integrate <strong>dynamic charts<\/strong> into WordPress, this guide will show you how to do it using <strong>Google Sheets<\/strong> as a data source.<\/p>\n\n\n\n<p>We\u2019ve previously discussed <strong>dynamic data<\/strong> and common data sources. Now, let\u2019s convert a <strong>static chart<\/strong> into a <strong>fully dynamic<\/strong> one using Google Sheets.<\/p>\n\n\n\n<p>\ud83d\udd39 <strong>Note:<\/strong> Ensure that the <code>allow_url_fopen<\/code> directive is <strong>enabled<\/strong> in your <code>php.ini<\/code> file for seamless integration.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Use Google Sheets for Dynamic Charts<\/strong><\/h2>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 1 \u2013 Select a Chart<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open <strong>Graphina \u2013 WordPress Chart Plugin<\/strong>.<\/li>\n\n\n\n<li>Choose the chart type where you want to display data from <strong>Google Sheets<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 2 \u2013 Change Data Source to Dynamic<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>chart data settings<\/strong>, switch the option from <strong>\u201cManual\u201d<\/strong> to <strong>\u201cDynamic\u201d<\/strong>.<\/li>\n\n\n\n<li>At this stage, a <strong>\u201cNo Data Available\u201d<\/strong> message might appear\u2014this is normal because the data source hasn\u2019t been connected yet.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 3 \u2013 Connect Google Sheets<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>Dynamic Data Options<\/strong>, choose <strong>\u201cGoogle Sheet\u201d<\/strong> as the data type.<\/li>\n\n\n\n<li>A <strong>URL input box<\/strong> will appear.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 4 \u2013 Get the Google Sheets URL<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open your <strong>Google Sheet<\/strong> and go to <strong>File &gt; Share<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>\u201cPublish to Web\u201d<\/strong> and change the format to <strong>CSV<\/strong>.<\/li>\n\n\n\n<li>Copy the generated <strong>CSV link<\/strong>.<\/li>\n\n\n\n<li>Paste this link into the <strong>Google Sheet URL box<\/strong> in Graphina.<\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udca1 <strong>Instant Update:<\/strong> The chart will <strong>automatically update<\/strong> as soon as you paste the link!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 5 \u2013 Adjust Data Elements<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>chart data settings<\/strong>, increase the number of <strong>data elements<\/strong> if needed.<\/li>\n\n\n\n<li>You will now see the chart updating with <strong>live Google Sheets data<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Graphina  - Dynamic Charts Using Google Sheets\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/m2vpXYuQ0Y8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Key Features &amp; Notes<\/strong><\/h2>\n\n\n\n<p>\u2705 <strong>Column-Wise CSV Support<\/strong> \u2013 Fetch data arranged in columns effortlessly.<br>\u2705 <strong>Automatic Updates<\/strong> \u2013 Any changes made in Google Sheets <strong>instantly reflect<\/strong> in WordPress charts.<br>\u2705 <strong>No Manual Data Entry<\/strong> \u2013 Pull data directly from a live Google Sheet without re-uploading files.<\/p>\n\n\n\n<p>With these simple steps, you can seamlessly integrate <strong>Google Sheets as a dynamic data source<\/strong> for WordPress charts, eliminating the hassle of manual updates! \ud83d\ude80<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Column wise CSV by google sheet | Iqonic Design\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/tAQ1mbZbX2M?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Introduction Google Sheets offers various charting options, but if you want to integrate dynamic charts into WordPress, this guide will show you how to do it using Google Sheets as a data source. We\u2019ve previously discussed dynamic data and common data sources. Now, let\u2019s convert a static chart into a fully dynamic one using Google [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"parent":235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-324","post","type-post","status-publish","format-standard","hentry","category-graphina"],"featured_image_src":null,"author_info":{"display_name":"wordpressadminiq","author_link":"https:\/\/documentation.iqonic.design\/graphina\/author\/wordpressadminiq\/"},"children":[],"_links":{"self":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/comments?post=324"}],"version-history":[{"count":1,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"predecessor-version":[{"id":326,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/324\/revisions\/326"}],"up":[{"embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/posts\/235"}],"wp:attachment":[{"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/documentation.iqonic.design\/graphina\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}