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
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"
Join BuildShip Community ->
An active and large community of no-code / low-code builders. Ask questions, share feedback, showcase your project and connect with other BuildShip enthusiasts.
Hire a BuildShip Expert ->
Need personalized help to build your product fast? Browse and hire from a range of independent freelancers, agencies and builders - all well versed with BuildShip.
Send a Support Request ->
Got a specific question on your workflows / project or want to report a bug? Send a us a request using the "Support" button directly from your BuildShip Dashboard.
Feature Request ->
Something missing in BuildShip for you? Share on the #FeatureRequest channel on Discord. Also browse and cast your votes on other feature requests.
