Skip to main content

Google Cloud Realtime Database

The Google Cloud Realtime Database node allows you to automate work in Google Cloud Realtime Database, and integrate Google Cloud Realtime Database with other applications. Robbot Automation has built-in support for a wide range of Google Cloud Realtime Database credentials, including writing, deleting, getting, and appending databases.

On this page, you'll find a list of operations the Google Cloud Realtime Database node supports and links to more resources.

!!! note "Credentials" Refer to Google Cloud Realtime Database credentials for guidance on setting up authentication.

!!! note "Examples and templates" For usage examples and templates to help you get started, take a look at Robbot Automation's Google Cloud Realtime Database list.

Basic Operations​

  • Write data to a database
  • Delete data from a database
  • Get a record from a database
  • Append to a list of data
  • Update item on a database

Example Usage​

This workflow allows you to receive updates of the position of the ISS every minute and push it to a database using the Google Cloud Realtime Database node. You can also find the workflow on Robbot Automation. This example usage workflow uses the following nodes.

1. Cron node​

The Cron node will trigger the workflow every minute.

  1. Click on Add Cron Time.
  2. Select 'Every Minute' from the Mode dropdown list.
  3. Click on Save to run the node.

2. HTTP Request node (GET)​

This node will make a GET request to the API https://api.wheretheiss.at/v1/satellites/25544/positions to fetch the position of the ISS. This information gets passed on to the next node in the workflow.

  1. Enter https://api.wheretheiss.at/v1/satellites/25544/positions in the URL field.
  2. Click on the Add Parameter button in the Query Parameters section.
  3. Enter timestamps in the Name field.
  4. Click on the gears icon next to the Value field and click on Add Expression.
  5. Enter the following expression: {{Date.now()}}. This expression will return the current timestamp.
  6. Click on Save to run the node.

3. Set node​

We will use the Set node to ensure that only the data that we set in this node gets passed on to the next nodes in the workflow.

  1. Click on Add Value and select 'String' from the dropdown list.
  2. Enter latitude in the Name field.
  3. Click on the gears icon next to the Value field and click on Add Expression.
  4. Select the following in the Variable Selector section: Nodes > HTTP Request > Output Data > JSON > 0 > latitude. You can also add the following expression: {{$node["HTTP Request"].json["0"]["latitude"]}}.
  5. Click on Add Value and select 'String' from the dropdown list.
  6. Enter longitude in the Name field.
  7. Click on the gears icon next to the Value field and click on Add Expression.
  8. Select the following in the Variable Selector section: Nodes > HTTP Request > Output Data > JSON > 0 > longitude. You can also add the following expression: {{$node["HTTP Request"].json["0"]["longitude"]}}.
  9. Click on Add Value and select 'String' from the dropdown list.
  10. Enter timestamp in the Name field.
  11. Click on the gears icon next to the Value field and click on Add Expression.
  12. Select the following in the Variable Selector section: Nodes > HTTP Request > Output Data > JSON > 0 > timpestamp. You can also add the following expression: {{$node["HTTP Request"].json["0"]["timestamp"]}}.
  13. Toggle Keep Only Set to true. We set this option to true to ensure that only the data that we have set in this node get passed on to the next nodes in the workflow.
  14. Click on Save to run the node.

4. Google Cloud Realtime Database node (push)​

This node will push the data from the previous node to the iss path in Google Cloud Realtime Database. If you have created a path with a different name, you can use that path instead.

  1. First of all, you'll have to enter credentials for the Google Cloud Realtime Database node. You can find out how to do that here.
  2. Select a project from the Project ID dropdown list.
  3. Select 'Push' from the Operation dropdown list.
  4. Enter a path in the Object Path field.
  5. Enter latitude, longitude, timestamp in the Columns / Attributes field.
  6. Click on Save to run the node.

!!! note "Activate workflow for production" This example workflow uses the Cron node, which is a Trigger node. You'll need to save the workflow and then click on the Activate toggle on the top right of the screen to activate the workflow. Your workflow will then be triggered as specified by the settings in the Cron node.