Ylem documentation
  • 🗒️General information
    • Introduction to Ylem
    • Quick start guide
    • Release notes
  • 🔬Open-source edition
    • Installation
    • Usage of Apache Kafka
    • Task processing architecture
    • Configuring integrations with .env variables
  • 💡Integrations
    • Connecting an integration
    • Library of integrations
      • Amazon Redshift
      • Apache Kafka
      • APIs
      • Atlassian Jira
      • AWS Lambda
      • AWS RDS
      • AWS S3
      • ClickHouse
      • ElasticSearch
      • E-mail
      • Google Big Query
      • Google Cloud SQL
      • Google Pub/Sub
      • Google Sheets
      • Immuta
      • Incident.io
      • Jenkins
      • Hubspot
      • Microsoft Azure SQL
      • MySQL
      • OpenAI ChatGPT
      • Opsgenie
      • PostgreSQL
      • PlanetScale
      • RabbitMQ
      • Salesforce
      • Slack
      • Snowflake
      • Tableau
      • Twilio. SMS
      • WhatsApp (through Twilio)
    • Initial demo data source
  • 🚡Pipelines
    • Pipeline management
    • Tasks
      • Aggregator
      • API Call
      • Code
      • Condition
      • External trigger
      • Filter
      • For each
      • GPT
      • Merge
      • Notification
      • Query
      • Pipeline runner
      • Processor
      • Transformer
    • Running and scheduling pipelines
    • Library of templates
    • Environment variables
    • Mathematical functions and operations
    • Formatting of messages
  • 📈Statistics and profiling
    • Statistics of runs
    • Slow tasks
  • 📊Metrics
    • Metric management
    • Using previous values of a metric
  • 💼Use cases, patterns, templates, examples
    • Use cases
    • Messaging patterns
      • Datatype Channel
      • Message Dispatcher
      • Messaging Bridge
      • Message Bus
      • Message Filter
      • Message Router
      • Point-to-Point Channel
      • Publish-Subscribe Channel
      • Pull-Push
    • Functional use cases
      • Streaming from Apache Kafka and messaging queues
      • Streaming from APIs
      • Streaming from databases
      • Data orchestration, transformation and processing
      • Usage of Python and Pandas
      • KPI Monitoring
      • OKRs and custom metrics
      • Data Issues & Incidents
      • Reporting
      • Other functional use cases
    • Industry-specific use cases
      • Finance and Payments
      • E-commerce & Logistics
      • Customer Success
      • Security, Risk, and Anti-Fraud
      • Anti-Money Laundering (AML)
  • 🔌API
    • OAuth clients
    • API Reference
  • 👁️‍🗨️Other resources
    • FAQ
    • Our blog on Medium
Powered by GitBook
On this page
  • Setting up integration
  • Step 1. Creating a service account with JSON credentials
  • Step 2. Enable Google Sheets API
  • Step 3. Create Google Sheet and grant access to it to the service account
  • Step 4. Create an integration
  • Step 5. Create a test pipeline and stream data

Was this helpful?

Edit on GitHub
  1. Integrations
  2. Library of integrations

Google Sheets

PreviousGoogle Pub/SubNextImmuta

Last updated 9 months ago

Was this helpful?

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. Select a project.

  2. 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

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:

In the Google Cloud console, .

Go to , select the project, and confirm enabling Google Sheets API.

💡
go to the Service accounts
https://console.developers.google.com/apis/api/sheets.googleapis.com/overview
Spreadsheet Id
Sheet Id