{"id":6932,"date":"2020-03-18T13:11:28","date_gmt":"2020-03-18T13:11:28","guid":{"rendered":"http:\/\/www.datapost.co.za\/help\/?page_id=6932"},"modified":"2025-03-07T13:13:38","modified_gmt":"2025-03-07T11:13:38","slug":"google-sheet-data-source","status":"publish","type":"page","link":"https:\/\/datapost.co.za\/help\/nfinityxid\/google-sheet-data-source\/","title":{"rendered":"Google Sheet as data source"},"content":{"rendered":"[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_fullwidth_header title=”Google Sheet as data source” _builder_version=”4.20.0″ _module_preset=”default” background_color=”#2c4166″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” min_height=”27.6px” custom_padding=”||2px|||” global_colors_info=”{}”]\n

Step-by-step guide on how to set up a Google Sheet as data source<\/strong><\/h4>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Forex-Google-Sheet-Example-Oct-2020.jpg” title_text=”Forex Google Sheet Example Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a01.\u00a0Create a Google Sheet by inputting the relevant data. Make sure that the first row of the document contains the column names.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_cta title=”Handy Tip” button_text=”Click Here” _builder_version=”4.20.0″ _module_preset=”default” background_color=”#2c4166″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]\n

If you want to include images in your presentation using a Google Sheet as data source, you will have to upload the images to nfinityX & input the Meta ID’s as per the above example in the Flag column: XID=Image Meta ID.<\/p>\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2022\/05\/XID-Publish-to-web-2.jpg” title_text=”XID Publish to web 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

2. Click on File, a menu will appear. Hover over Share, move to the right and click on Publish to web to publish your Google Sheet.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Confirm-Action-Google-Sheet-Oct-2020-1.jpg” title_text=”Confirm Action Google Sheet Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a03. Click on the Publish button to publish the entire document. A window will appear, click on Ok to confirm that you want to publish your selection.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_cta title=”Important Note” button_text=”Click Here” _builder_version=”4.20.0″ _module_preset=”default” background_color=”#2c4166″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]\n

 <\/p>\n

Make sure that you share the Google Sheet with anyone with the link.<\/p>\n

 <\/p>\n

1. Click on the green Share button in the top right corner of the Google Sheet.<\/p>\n

2. Click on Get Link.<\/p>\n

3. Click on the drop-down arrow and select Anyone with the link<\/em>.<\/p>\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Click-on-api-manager-Oct-2020.jpg” title_text=”Click on api manager Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

4.\u00a0Click on the Api Manager in XID to open it.<\/span><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Click-on-Google-Sheets-button-Oct-2020-1.jpg” title_text=”Click on Google Sheets button Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

5. Click on the Google Sheets button. A window will open.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Google-Sheet-ID-and-tab-number-Oct-2020.jpg” title_text=”Google Sheet ID and tab number Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

6. Complete the <\/span>Google Sheet ID & Sheet Tab Number. Click on <\/span>Apply.<\/span><\/p>\n

<\/span><\/p>\n

<\/span>Important note:<\/strong><\/p>\n

You will find the Google Sheet ID in the address bar. Only include everything after d\/ and before \/edit<\/span><\/p>\n

https:\/\/docs.google.com\/spreadsheets\/d\/<\/span>1PjTPBk1P_F7T1IFABgjgraE7b5vx1Z5MBGwtClaVk-c<\/strong>\/edit#gid=0<\/span>
<\/span><\/p>\n

<\/span><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Api-data-Oct-2020.jpg” title_text=”Api data Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

7. The data will appear in the panel on the left. Click on the Create Table button to select the data that you want to add to your presentation.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2022\/05\/XID-Click-on-Create-Table.jpg” title_text=”XID Click on Create Table” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

8. The table will appear in the middle panel.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/10\/Items-on-canvas-Oct-2020.jpg” title_text=”Items on canvas Oct 2020″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

9. Drag the table into the desired location on the canvas. The data in your presentation will update when you make changes to your Google Sheet.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Update Interval” image=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2022\/05\/XID-General-Settings.png” _builder_version=”4.16″ _module_preset=”default” header_level=”h6″ header_font=”|700|||||||” header_text_align=”center” header_text_color=”#7D7D7D” border_radii_image=”on|5px|5px|5px|5px” global_colors_info=”{%22gcid-03def316-d668-49f5-8a45-92a0264755aa%22:%91%93}”]\n

The data will update as per the update interval set under General Settings.<\/span><\/p>\n

D<\/span>efault 15 seconds.<\/span><\/p>\n[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_cta title=”Important Note” button_text=”Click Here” _builder_version=”4.20.0″ _module_preset=”default” background_color=”#2c4166″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]\n

If you add rows of data to your Google Sheet, you will have to set it up again.<\/p>\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”]\n

Menu board example using a Google Sheet as data source<\/strong><\/span><\/h4>\n[\/et_pb_text][et_pb_image src=”https:\/\/datapost.co.za\/help\/wp-content\/uploads\/2020\/03\/Menu-Board-example.png” title_text=”Menu-Board-example” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”30%” max_width=”30%” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_button button_url=”https:\/\/datapost.co.za\/help\/nfinityxid\/google-sheet-data-source\/” button_text=”To Top” _builder_version=”4.20.0″ _module_preset=”default” custom_button=”on” button_text_color=”#FFFFFF” button_bg_color=”#2c4166″ button_border_color=”#2c4166″ button_icon=”2||divi||400″ hover_enabled=”0″ global_colors_info=”{}” button_bg_enable_color=”on” sticky_enabled=”0″][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

Step-by-step guide on how to set up a Google Sheet as data source        \u00a01.\u00a0Create a Google Sheet by inputting the relevant data. Make sure that the first row of the document contains the column names.If you want to include images in your presentation using a Google Sheet as data source, you will […]<\/p>\n","protected":false},"author":148,"featured_media":0,"parent":6497,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\n

How to set up the Google Sheet<\/h3>\n\n\n\n

1. Create a Google Sheet by inputting the relevant data. Make sure that the first row of the document contains the column names.<\/p>\n\n\n\n

2. Publish the sheet to the web.<\/p>\n\n\n\n

3. Click on the API Manager in XID.<\/p>\n\n\n\n

4. Click on the Google Sheets button.<\/p>\n\n\n\n

5. Fill in the Google Sheet ID<\/em> & Sheet Tab Number<\/em>. Click on Apply<\/em>.<\/p>\n\n\n\n

6. The data will appear in the panel on the left.<\/p>\n\n\n\n

7. Click on the items you want to include in the presentation. They will appear in the middle panel as you click on them.<\/p>\n\n\n\n

8. Drag the items into the desired locations on the canvas.<\/p>\n\n\n\n

Menu board example using a Google Sheet as data source<\/h4>\n\n\n\n
\"\"<\/figure>\n","_et_gb_content_width":"","footnotes":""},"class_list":["post-6932","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/users\/148"}],"replies":[{"embeddable":true,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/comments?post=6932"}],"version-history":[{"count":42,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6932\/revisions"}],"predecessor-version":[{"id":18193,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6932\/revisions\/18193"}],"up":[{"embeddable":true,"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/pages\/6497"}],"wp:attachment":[{"href":"https:\/\/datapost.co.za\/help\/wp-json\/wp\/v2\/media?parent=6932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}