Integrate Google Sheets and JSON to automate workflows with scalable backend
Connect Google Sheets and JSON 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 Google Sheets and JSON
Popular Templates With Google Sheets and JSON
Explore our popular Google Sheets & templates below. Click. Remix. Ship!
Node stack
Supported Triggers & Actions
Google Sheets NODES
Add Row
Adds row(s) of data in a Google Sheet.
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.
Create Sheet
Creates a new Google Spreadsheet.
Get Sheets
Fetch a Google Spreadsheet using the Google Sheets API
JSON NODES
Append Array to JSON File
Appends an array of objects to a JSON file. If the file or folder path doesn't exist, it creates it
script
Concat Property Values
Extracts and concatenates specific property values from an array within a JSON object and returns the concatenated string.
script
Extract & Join By Key
Extracts a specific key from each object within the array and concatenates the values into a single string.
script
Is Valid JSON
Check if a given string is valid JSON
script
JSON to CSV
Creates a CSV file from an array of JSON objects, stores it in the GCP Storage Bucket, and returns the public download URL.
script
Parse JSON
Converts a JSON string back into a JavaScript object
script
Stringify JSON
Convert a JSON object to a string
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.
