Do your Evening Gratitude Ritual!
Connect popular automations
Quickly and easily enable Applets using Beeminder and Google Sheets.
Build your own Beeminder and Google Sheets automations
Triggers (If this)
-
Zeno alert for a specific goal
This Trigger fires when the goal is close to derailing. It will begin firing according to the goal's reminder settings.
-
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
Datapoint added to any goal
This Trigger fires every time a datapoint is added to any goal.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Datapoint added to a specific goal
This Trigger fires every time a datapoint is added to a specific goal.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Beemergency day on any goal
This Trigger fires when any goal moves into the red (imminent derailment).
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Beemergency day on a specific goal
This Trigger fires when a specific goal moves into the red (imminent derailment).
-
N days of safety buffer for any goal
This Trigger fires when any goal gets too close to derailing. You choose how many days before derail it should fire when you set up the Trigger.
-
N days of safety buffer for a specific goal
This Trigger fires when a specific goal gets too close to derailing. You choose which goal and how many days before derail it should fire when you set up the Trigger.
Zeno alert for a specific goal
This Trigger fires when the goal is close to derailing. It will begin firing according to the goal's reminder settings.
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
Datapoint added to any goal
This Trigger fires every time a datapoint is added to any goal.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Datapoint added to a specific goal
This Trigger fires every time a datapoint is added to a specific goal.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Beemergency day on any goal
This Trigger fires when any goal moves into the red (imminent derailment).
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Beemergency day on a specific goal
This Trigger fires when a specific goal moves into the red (imminent derailment).
N days of safety buffer for any goal
This Trigger fires when any goal gets too close to derailing. You choose how many days before derail it should fire when you set up the Trigger.
N days of safety buffer for a specific goal
This Trigger fires when a specific goal gets too close to derailing. You choose which goal and how many days before derail it should fire when you set up the Trigger.
Queries (With)
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
History of Zeno alert for a specific goal
This query returns a list of when the goal was close to derailing.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of Zeno alert for a specific goal
This query returns a list of when the goal was close to derailing.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
-
Add datapoint
This Action will add a new datapoint to a Beeminder goal.
-
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
-
Charge me
This Action will charge your credit card the specified amount. If you don't have a credit card on file with Beeminder, or if there's a problem trying to charge it, we'll email you to let you know.
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
Add datapoint
This Action will add a new datapoint to a Beeminder goal.
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Charge me
This Action will charge your credit card the specified amount. If you don't have a credit card on file with Beeminder, or if there's a problem trying to charge it, we'll email you to let you know.
How to connect Beeminder and Google Sheets
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Beeminder and Google Sheets accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Beeminder
Beeminder is a tool for data nerds to commit to progress towards goals. You specify any graphable goal (these Applets assume you've created one) and Beeminder plots your progress. Keep your datapoints on the right side of the Bright Red Line or Beeminder will literally charge you money.
Beeminder is a tool for data nerds to commit to progress towards goals. You specify any graphable goal (these Applets assume you've created one) and Beeminder plots your progress. Keep your datapoints on the right side of the Bright Red Line or Beeminder will literally charge you money.
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.