Connect BloomSky Weather to Google Sheets and unlock powerful automations

This Trigger fires every time your specified device uploads data to the server.

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.

This Trigger fires at the specific time set by you each day with a picture at that time from your selected device.

This trigger fires when a new worksheet is added to a spreadsheet you specify.

This Trigger fires when your specified device's time-lapse is ready, with a url of the time-lapse.

This trigger fires when a new row is added to a spreadsheet you specify.

This Trigger fires every time it is raining in the location of the specified device.

This trigger fires when a particular cell is updated within the spreadsheet you specify.

This Trigger fires every time the temperature exceeds a level set by you.

This Trigger fires every time the temperature is below a level set by you.

This Trigger fires every time the device you chose uploads new image. Note that this Trigger won't fire at night when the camera is off.

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

This query returns a list of your previous bloomsky picture of the days.

This query returns the current value of a single cell in your spreadsheet.

This query returns a list of your recent specified device's time-lapses.

This query returns a list of when a new row is added to a spreadsheet you specify.

This query returns a list of every time your specified device uploads data to the server.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

This query returns a list of rain detections by the specified device.

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.

This query returns a list of when the temperature was below a level set by you. Note: this query will only return future events after this Applet is created.

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This query returns a list of every time the device you chose uploads new image.

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.

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.