- Home
- Resources
- Integrations
- Botsheets
Botsheets Make integrationAutomate Botsheets with Make.
Can Make read and update your Botsheets data without code? Yes: the Botsheets Make integration gives you 4 modules, 2 searches and 2 actions, and no trigger. This guide is for people who know Botsheets but are new to Make, and it walks you from connection to a first working scenario.
Verified Trustpilot reviews · AI, automation & growth agency
What can the Botsheets Make integration do for you?
The Botsheets Make integration lets a Make scenario (the automation you build, a chain of steps) look up rows and gallery items in Botsheets and change a cell, with no code. Each step is a module, one brick of the scenario. Botsheets has no trigger in Make, so something else starts the run: another app or a schedule.
Keep a status column up to date. When a deal closes in your CRM, a scenario runs Search Rows to find the matching row in Botsheets, then Edit a Cell writes the new status. Nobody has to open the sheet to change it by hand.
Feed another tool with your gallery. List Gallery Items pulls the items of a gallery so the next module, from any app, can post them, file them or send them in a message. Each item travels as one bundle, meaning one item passed from a module to the next.
Reach what the menu does not show. Make an API Call uses the same connection to call any endpoint of the Botsheets API, which is handy since the list of modules is short.
Know the limits before you build: Make itself says its Botsheets documentation is incomplete, because little public information exists about the app. Test every module with real data before relying on it, and keep the Make troubleshooting guide close. If you are still weighing tools, the n8n vs Make comparison helps, and the Make training covers scenario basics step by step.
How do you connect Botsheets to Make?
- 01
Add a Botsheets module
Open any Botsheets module in your scenario and click Create a connection. A connection is your Botsheets account linked to Make once, then reused by every Botsheets module you add later.
- 02
Name the connection
Give the connection a name if you like, for example the workspace or client it belongs to. It is optional, but a clear name saves you from guessing when several accounts sit side by side in Make.
- 03
Authorize and save
Either approve Make on the Botsheets page that opens, or paste the key Botsheets gives you, depending on what the window asks for. Then click Save and the module is ready to fill in.
Your first scenario with Botsheets and Make
GoalWhen another app sends a new piece of data, Make finds the matching row in Botsheets and updates one of its cells.
- 01
Create the scenario
Go to the Scenarios page, create a new scenario and click the +. Since Botsheets has no trigger, pick the module of the app that should start the run, like a form or a CRM.
- 02
Add Search Rows
Click the + on the right of that first module, search for Botsheets and pick Search Rows. Click Create a connection if this is your first Botsheets module, then fill in its fields.
- 03
Add Edit a Cell
Add Edit a Cell after the search. Map the row found by Search Rows into it, then map the value that came from the first app. Make shows the data from earlier modules as you click each field.
- 04
Test with Run once
Click Run once and trigger the first app with a test record. Open each module to read the bundles it received, and check the cell in Botsheets. A search that finds nothing sends nothing downstream.
- 05
Schedule and switch on
Set the schedule on the first module, which is every 15 minutes by default, and switch the scenario on. On the Free plan, 15 minutes is also the shortest interval between two scheduled runs.
The 4 Botsheets modules in Make
Botsheets gives you 4 modules. For each one: what it does for you, when to reach for it, and what to watch out for.
Edit a Cell
ActionIn the docs onlyWrites a new value into one cell, so your Botsheets data reflects what just happened in another tool without anyone typing it in.
List Gallery Items
SearchIn the docs onlyReturns the items of a Botsheets gallery as separate bundles, so the next modules can handle them one at a time.
Make an API Call
ActionIn the docs onlyOpens the whole Botsheets API to your scenario, using the connection you already created, so a missing module no longer blocks you.
Search Rows
SearchIn the docs onlyFinds the rows that match what you are looking for and hands each one on as its own bundle, ready for the next module to read or change.
Need help automating Botsheets with Make?
A person reads every message.