Integrate GSheets using Datasets | The Humane Club Made with Humane Club
Hi 👋 I'm Dhara, the founder of Humane Club. We are now selectively onboarding.
Software & training to maintain your web presence
Humane replaces workarounds, messy plugins, and daily frustrations with built-in workflows, effortless organization, and clever features that levels-up WordPress in meaningful ways. Also, get insights on how to write copy and run your site.
Start a conversation
Contact Us
Start a conversation
Humane replaces workarounds, messy plugins, and daily frustrations with built-in workflows, effortless organization, and clever features that levels-up WordPress in meaningful ways. Also, get insights on how to write copy and run your site.

Integrate GSheets using Datasets

Published Jan 10, 2020
Updated Mar 25, 2021

Quick summary

  • Who can do it? Administrators, Editors, Authors, Contributors
  • How to reach it? Assets > Data Store

What, Why

Why reinvent the wheel? Data Pack runs off data from the most widely used database for CSV files: Google Sheets.

Connect a published Google Sheet. For more details, scroll down to read how to.


How

Before connecting the Google Sheet URL, ensure that the dataset is clean and structure it as one sizeable horizontal CSV file. Each row should represent the same entity — an incident, a district, a country. Publish the Google Sheet and also ensure that the Google Sheet link is made public.

Name the dataset and enter the published URL of the Google Sheet.

Once you create the dataset, it will take you to edit page where you need to set the properties for each column. Until this step is done, you cannot use the dataset in your 10000ft visualizations.

  • Datatype: set what type of data your column holds. We support 16 datatypes – text, select, multi-select, image, date, datetime, number, accounting, percent, country ISO2, state ISO2, district ISO2, latitude, longitude, URL and email.
  • Alias: give readable and easy to understand name to the column. This name will be shown in filters, weights, parameters and on tooltips.
  • Description: describe the column name. The description of the column will be shown in the filters dropdown. The max length is 140 characters.

Once I create dataset, can I change the column names?

No, you cannot rename, add or remove columns once the dataset is created.

What if rows of my dataset change? How do I ensure it gets reflected in the visualization?

Yes you can show the updated data. Go to Edit page of the dataset and click on save button at the bottom of the page. We will fetch the updated data from the google sheet.

By
Published
Updated