# 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](https://console.cloud.google.com/iam-admin/serviceaccounts?walkthrough_id=iam--create-service-account-keys\&start_index=1#step_index=1). 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 , 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: