​
Introduction

Structured row data of any kind, including analytics, can be easily exported to Google Sheets using valmi.io from Warehouses. This allows you to share data with your team, clients, or other stakeholders in a familiar format.

​
Google Sheets Configuration

From Google Sheets, create a new spreadsheet and give it a name. If you want to use an existing spreadsheet, you need to have edit access for it. Copy the url of the spreadsheet. For example, it looks similar to https://docs.google.com/spreadsheets/d/1BMkO9GH_-_eDr-QjIiQv8LDBGjrBoJmsWpo7jlzqeadfd/

​
Creating a Google Sheet Connection on valmi.io

Go to destinations on valmi.io and create a new destination. Select Google Sheets as the destination. On the next page, enter the name of the connection, and paste the spreadsheet url. Additionally, Sign in with Google is required to perform OAuth authentication with Google to give access to the spreadsheet. Click on the Next button to connect to the spreadsheet and to test and create the connection.

​
Setting up a Sync

  1. ​
    Supported Destination Modes

Google Sheets supports the following destination modes. Please refer to the Destination Sync Modes for more information on the different destination modes.

Destination ModeSupported
Upsert✅

  1. ​
    Mapping Source Columns to Destination Fields

While creating a Sync on valmi.io, you can select a source table and then you can choose the previously created Google Sheets connection as the destination.

The next screen lets the user map the source columns onto the header fields of the Google Sheet. The picture below shows that we have selected Upsert destination sync mode. customer_id has been selected as the Primary Key for the Warehouse source. The source fields first_name, last_name, active, last_update have been mapped to the custom destination fields g_first_name, g_last_name, g_active, updatedAt respectively.

In the next screen, you can choose a schedule for the sync and finally create the sync.

  1. ​
    Verifying data loaded into the Google sheet

You can confirm the number of records sent to Google sheets API from the Sync Runs Page.

You can also confirm the data loaded into Google Sheets directly from the web browser or the Google Sheets App. The picture below shows the data loaded for this example on to the Google Sheet we have provided.