We're programmatically thrilled to announce the release of no-code Automations in Spreadsheet.com.

Now you can quickly and easily automate repetitive work and integrate with other popular work tools using Spreadsheet.com automations built right into your spreadsheets. For example, you can create automations to:

• Notify task owners 2 days before each task's start date
• Send a Slack notification to the entire team when a deal is closed
• Move a row to a different worksheet when a ticket is archived

Automations can be created by anyone. You don't need to know how to write code or create complicated scripts.

📹 Watch an overview video (6 mins)

‍

‍

Creating and Editing Automations

To create an automation, click the robot icon in the upper right of your workbook’s header.

You’ll be taken to a library of over 50 automation recipes. Recipes are ready-to-use automation templates that are fast and easy to start from.

Automation recipes available today include:

• Send a custom notification to Spreadsheet.com users when a date arrives
• Create, update, copy, or move a row from one worksheet to another when a column value changes
• Send a notification to Slack or Microsoft Teams when a column value changes
• Send an email from your Gmail account when a Form is submitted

Spreadsheet.com automations are defined visually in a workflow editor. Each automation always has one Trigger block and one or more Action blocks. The trigger block determines when the automation will run, and the action blocks define the actions that will be performed. You can optionally add conditional logic by inserting condition blocks.

Each action block can have multiple actions and you can reorder them to determine the execution sequence.

Custom notification messages and emails can include row data by inserting column placeholders in the subject and message body.

Read more in the community announcement: Product Updates - June 8, 2021 - Automations and Integrations‍

‍

‍What we're working on

A few features we're busy working on now:

• Public Sharing and Embedding
  Ability to embed a workbook in an external site or third party application, such as a blog, website, or SaaS app. This will include the ability to share a public read only link to the workbook that does not require a user to have a Spreadsheet.com account to view it.
  ‍
• Zapier
  We’re working toward adding Spreadsheet.com to the Zapier app directory, which will allow you to create zaps that connect Spreadsheet.com workbooks with over 3,000 other apps and sites.
  ‍
• API
  Ability to programmatically work with workbooks, worksheets, views, rows, cells, attachments, relationships, and more, via a REST API.
  
  ‍

‍More updates

‍As usual, whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community.  

• Product Updates - June 3, 2021
• Product Updates - April 10, 2021
• Product Updates - February 27. 2021
• Product Updates - January 30, 2021

‍