Using Data stores

Learn how to use data stores to share data between automations.

When handling data between two or more automations, a data store is required. This can be useful when dealing with large data sets or needing the same data in many places and looking for ways to centralize the external data request or providing greater efficiency.

 

The most common use case is centralizing data pulling from an external source and providing it to multiple other automations, e.g.:

  • Google Sheets
  • Tableau
  • Google Analytics
  • BigQuery
  • Appsflyer
  • Adjust
  • Any other API
 

How to set up, update, and retrieve data stores

Set-Up a Data Store

Notion image

When you’re in the main overview view, click Data Stores in the left navigation. Then hit “New Data Store, add an identifier, an optional schema and any data.

 

Update a data store

In order to set or update a data store, we can use the Update Data Store node. We simply select the data store we want to update by its id and pass it the new data.

Notion image
Notion image
 

Retrieve a data store

To retrieve a variable and use its value, we can use the Fetch Data Store node. We need to select the data store by id and the node will return its current value.

Notion image
 

Patch a data store

To change the value or add data to a data store without updating it entirely, use the Patch Data Store node. We need to select the data store by its id and add any patches.

Notion image

Similar to the Patch JSON node, this example will add a field parameter to the existing data store.

Did this answer your question?
😞
😐
🤩

Last updated on September 9, 2023