Import from Google Sheets

This Google Sheets integration allows you to transform your live spreadsheet data into professional charts that automatically update whenever you edit the source sheet. Stop manually exporting and importing files; follow these simple steps to create a seamless, real-time data visualization workflow that keeps your reports, dashboards, and embedded charts perpetually accurate and insightful.

In this guide, we’ll walk you through the step-by-step process of connecting your Google Sheet to InstaCharts.

To sync a spreadsheet from Google Sheets, first make sure you are logged into your InstaCharts account. If you don’t have an account, sign up here.

Tip

This guide is written for sharing a Google Sheet, but can be applied to other spreadsheet files in Google Drive such as Google Docs, excel files, csvs and json files.

Step 1: Prepare Your Google Sheet

Before you start, make sure your Google Sheet is ready for integration. Here are some key considerations:

• Data Organization: Ensure your data is well-structured in a table format.
• Column Headers: Use clear and descriptive headers for your columns. These will be used as labels in your charts.
• Data Types: Verify that your data is in the correct format (e.g., numbers, dates, text). Incorrect data types can lead to unexpected results.

Step 2: Share Your Google Sheet

In Google Drive, find the file you’d like to connect. Right click on the file and click Share.

There are two ways to share this data with InstaCharts.

Share your Google Sheet with anyone to allow InstaCharts access to the file

Share with anyone

Underneath General Access, change “Restricted” to “Anyone with the link”. This allows anyone with the link to view your file.

In the Role dropdown, InstaCharts only requires Viewer access.

Share with the InstaCharts account

If you’d rather not share your file publicly, you can share it with an InstaCharts email address.

In the “Add people” text box, paste in charts@instacharts.iam.gserviceaccount.com . Change the role dropdown to “Viewer” and press Send to update access.

InstaCharts should now be able to read your file.

Note

Be sure to copy the Google Sheet’s shared link before closing the Share window

Step 3: Connect the Google Sheet to InstaCharts

To import a spreadsheet from Google Sheets, click New -> New Sheet from your InstaCharts workspace.

From the New Sheet dialog, click the middle option “Connect to a data source”.

New Sheet Dialog - Connect to a data source can load a file from Google Sheets

On the next screen, select Google Drive from the source dropdown. Then enter the copied link from step 2 into the Google Drive url text box.

New Sheet Dialog - A Google Sheets url has been entered

Click Next to view a preview of the Google Sheet.

Tip

Select Google Drive as a source to read Google Sheets, Google Docs, and spreadsheet files uploaded to Google Drive

Data Source Preview

If the file is successfully shared, a preview of it will show in the Preview window. If nothing is showing, recheck that your file was shared correctly with InstaCharts in step 2.

While Google Sheets and excel files in Google Drive already contain their encoding types, other Google Drive files may need a different encoding type selected. If the characters shown in the preview window don’t look correct, try changing the file’s encoding type.

File Preview - Make sure characters are displaying correctly before importing your spreadsheet

Tip

The most common modern character encoding is Unicode UTF-8. If Auto doesn’t work for your spreadsheet, try UTF-8 next.

Imported Spreadsheet

Once your sheet has been imported, it will automatically open to a chart created with your data.

A chart is instantly created from a spreadsheet

Note

Free accounts are limited to files 2MB or less and will only process up to 500 rows per spreadsheet

Check Formatting

Click the Data tab to view your processed spreadsheet data. Column types are autodetected based on the data each contains. Column names are pulled from the header row of the spreadsheet.

To edit column names, click Edit Column from each column’s header menu on the data tab.

View spreadsheet data from the Google Sheet on the Data Tab

Troubleshooting

The preview window is empty or shows an error. The most common cause is that the file is not shared correctly. Go back to Step 2 and confirm that either “Anyone with the link” is enabled, or that charts@instacharts.iam.gserviceaccount.com has been added as a Viewer.

Characters look garbled or incorrect. The file encoding may not match. Try selecting UTF-8 from the encoding dropdown in the preview window.

Only some rows are imported. Free accounts are limited to 500 rows per spreadsheet. Upgrade your plan or trim the source sheet to stay within the limit.

I updated my Google Sheet but the chart is not refreshing. InstaCharts does not automatically poll for changes. Use the Re-sync settings to configure how often your sheet is refreshed, or trigger a manual re-sync from your workspace.

My Google Doc or Drive file is not loading. Make sure you are selecting Google Drive as the source in the New Sheet dialog - this source supports Google Sheets, Google Docs, and uploaded spreadsheet files stored in Drive.

Frequently Asked Questions

Does InstaCharts support Google Docs? Yes. Select Google Drive as your source and paste the shareable link to your Google Doc. The same sharing rules apply.

Can I import Excel or CSV files stored in Google Drive? Yes. As long as the file is shared with InstaCharts (either publicly or via the service account email), you can import it the same way as a Google Sheet.

How often does the data refresh? Data does not refresh automatically by default. You can configure a sync schedule or trigger a manual re-sync from your workspace. See Re-sync settings for details.

Is my data secure? InstaCharts only requests Viewer access to your file. No write access is needed or requested. You can revoke access at any time by removing InstaCharts from the Share settings in Google Drive.

Next Steps

Now that your Google Sheets file is connected to InstaCharts, read on to discover the next steps:

How to Re-sync data with Google Sheets

How to Download Chart Images

How to Share a Chart via a link