Google Sheets

Integration type: Write

Integration with Google Sheets allows you to stream data from any data source to spreadsheets in real-time.

Data for the connection:

Setting up integration

Step 1. Creating a service account with JSON credentials

1. In the Google Cloud console, go to the Service accounts.

2. Select a project.

3. Create a new service account or select an existing one.

Steps 2 and 3 are optional and are not needed if you want to make basic Ylem's integration work. As soon as the service account is created, create a key with JSON credentials for it:

1. Click the email address of the service account that you want to create a key for.

2. Click the Keys tab.

3. Click the Add key drop-down menu, then select Create new key.

4. Select JSON as the Key type and click Create.

Clicking Create downloads a service account key file. After you download the key file, you cannot download it again.

Step 2. Enable Google Sheets API

Go to https://console.developers.google.com/apis/api/sheets.googleapis.com/overview, select the project, and confirm enabling Google Sheets API.

Step 3. Create Google Sheet and grant access to it to the service account

Go to the Google Sheet you want to stream data to, click on File -> Share -> Share with others, and share it with the service account you just created.

Step 4. Create an integration

Now you can create an integration in Ylem by adding JSON credentials, Spreadsheet ID, and Sheet ID. The last two parameters you can get from the URL of the spreadsheet you just created:

Step 5. Create a test pipeline and stream data

Now you can create a pipeline and run it to stream data to the new spreadsheet:

If you run the pipeline now, the new content should appear in the spreadsheet: