Integrate MongoDB and Google Sheets to automate workflows with scalable backend
Connect MongoDB 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 MongoDB and Google Sheets
Popular Templates With MongoDB and Google Sheets
Explore our popular Google Sheets & templates below. Click. Remix. Ship!
🛋️
Chat with Google Sheets
Create an AI Assistant that can chat with your data on Google Sheets. This template is connected to a Furniture store's inventory data on Google Sheets and users can chat with the...
OpenAI Google Sheets
🗣️
Audio Transcribe & Translate
Given a speech audio file, this template transcribes it and then translates it into a target language. This includes creating an output audio file in the target language using Goog...
Google Translate OpenAI
Node stack
Supported Triggers & Actions
MongoDB NODES
MongoDB Trigger
Trigger a workflow on data changes in your MongoDB database. Parse the incoming data payload from MongoDB and create a workflow connected to other apps. Check out the [Full Documentation](https://docs.buildship.com/trigger-nodes/mongodb-trigger) on how connect to your MongoDB project.
Delete Document
Deletes a document from a specified collection in MongoDB by document ID and returns the operation response.
Fetch Document
Fetches and returns the entire document data from a MongoDB collection based on the given document ID.
Full Text Search
This performs a full-text search in a specified MongoDB collection, conducts the search, returns matched documents. To enable full-text search (FTS) in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#full-text-search) on setting up MongoDB Search Index.
Hybrid Search
This performs a hybrid search in a specified MongoDB collection, conducts the search, returns matched documents. To enable semantic search in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#hybrid-search) on setting up search indexes.
Insert Document
Inserts the given data into a MongoDB collection and returns the ids of the inserted documents.
Query Collection
Queries for multiple documents in a MongoDB collection using connection string, database name, collection name, query, sort, and projection.
Semantic Search
This performs a semantic search in a specified MongoDB collection, conducts the search, returns matched documents. To enable semantic search in MongoDB, follow this [guide](https://docs.buildship.com/tutorials/mongodb-search#semantic-search) on setting up vector search index.
script
Update Document
Updates a specific document in a MongoDB collection using the updateOne function and returns the operation result.
script
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.
