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
In the Google Cloud console, go to the Service accounts.
Select a project.
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:
Click the email address of the service account that you want to create a key for.
Click the Keys tab.
Click the Add key drop-down menu, then select Create new key.
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:
Last updated