Importing data from Google Sheets

The process for importing a Google Sheet using a connector is very similar to Excel. However, a big advantage the Google Sheet connector has over the Excel connector is that it can run on a schedule as part of the connector.

Loading your Google Sheet data into the Domo cloud

The following steps demonstrate how to load Google Sheet data:

1. Click the DATA option on the main menu.
2. Click on the CLOUD APP menu item, which takes you to the Data Connectors page.
3. Enter sheets in the Search Connectors box.
4. Click on Connect in the Google Sheets connector tile.
5. Then click on the GET THE DATA button.
6. If it is the first time you are acquiring data from Google Sheets, you will need to set up account credentials by clicking CONNECT and following the process.
7. After allowing Domo to use your Google credentials, click NEXT in the Credentials section.
8. In the Details section, click on the … link in the Google Sheet Choose...