Integrate OPENFORMAT and Google Sheets to automate workflows with scalable backend

Connect OPENFORMAT and Google Sheets nodes to in your workflow. Integrate with any tool or database and ship powerful backend logic and APIs instantly - No code required!

Getting Started

How To Connect OPENFORMAT and Google Sheets

01

Step 1: Add Trigger Node

It is the node that will start your workflow execution.

Step 1: Add Trigger Node

It is the node that will start your workflow execution.

01

Step 1: Add Trigger Node

It is the node that will start your workflow execution.

02

Step 2: Connect OPENFORMAT and Google Sheets

It is the node that will start your workflow execution.

Step 2: Connect OPENFORMAT and Google Sheets

It is the node that will start your workflow execution.

02

Step 2: Connect OPENFORMAT and Google Sheets

It is the node that will start your workflow execution.

03

Step 3: Integrate with any other tool or service

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

Step 3: Integrate with any other tool or service

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

03

Step 3: Integrate with any other tool or service

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

04

Step 4: Execute Workflow

Once done, test and click ship to run as an API or scheduled job.

Step 4: Execute Workflow

Once done, test and click ship to run as an API or scheduled job.

04

Step 4: Execute Workflow

Once done, test and click ship to run as an API or scheduled job.

Node stack

Supported Triggers & Actions

OPENFORMAT NODES

Check Missions

Checks whether the user has completed all of the actions that make up a mission, and whether they have already been rewarded for completing the mission. [Full Documentation Here](https://docs.openformat.tech/no-code/buildship/nodes/check-missions)

Create web3 Account

Creates a web3 account for your user. You can learn more about what this is and how it benefits your users here.

Get Leaderboard

Returns a leaderboard based on the amount of experience points (XP) users have earned.

Get User Information

Returns the user's experience point (XP) balance, the badges they have collected and the actions they have completed within that specific dApp.

Reward Badge

Reward a user with a badge for completing an action or mission. [Full documentation here](https://docs.openformat.tech/no-code/buildship/nodes/reward-badge)

Reward XP

Reward a user with experience points (XP) for completing an action.

Google Sheets NODES

Add Row

Adds row(s) of data in a Google Sheet.

script

Batch Update Sheet

Batch updates values in a Google Sheet. This node is technically a bit complex to entertain more versatile use cases. To simply add values to a Google Sheet, check out the "Add Row" node.

script

Create Sheet

Creates a new Google Spreadsheet.

script

Get Sheets

Fetch a Google Spreadsheet using the Google Sheets API

script

Blog posts & Tutorials

Recommended
Reads

Below are recommneded blogs that will help in your journey

Support

Need Help?

Here are some helpful resources to get you "unstuck"

Start building your
BIGGEST ideas
in the *simplest* of ways.

Start building your
BIGGEST ideas
in the *simplest* of ways.

Start building your BIGGEST ideas in the *simplest* of ways.