Product Updates: Web API, webhooks, and 10 new templates
co-founder & CEO
What's new in Spreadsheet.com?
We’re delighted to launch the Spreadsheet.com Developer API, allowing developers to programmatically interact with Spreadsheet.com to create custom apps and integrations.
We also added two new automation triggers for “When a new row is created” and “When a row is updated”, and we rolled out support for Webhooks in Spreadsheet.com automations with a new “Post to Webhook” automation action.
In addition, we published 10 new templates for use cases ranging from Project and Product Planning to Sales Planning and Personal Travel, as well as 6 new use case guides and 5 new work management articles.
Webhooks, also known as web callbacks or HTTP push APIs, are a way for apps to send other apps real-time data. The new Webhook automation action in Spreadsheet.com allows you to post updates to servers or third-party applications whenever automations are triggered in your worksheets.
Webhooks work in conjunction with the Spreadsheet.com Developer API. For more information on working with Webhooks, see Post to a Webhook.
New Trigger Types
Two new automation Trigger types have now been added, giving you more ways to automate work inside your worksheets.
The “When a new row is created” trigger fires 3 minutes after a row is initialized with data (i.e. when a cell is first populated with data in an empty and uninitialized row), allowing time for data entry to be completed before the trigger runs.
The “When a row is updated” trigger fires immediately whenever data in a cell within a row changes.
Rich Text Data Type We're working on a new data type allowing rich formatted text in cells with markdown support, a popular feature request.
Reports Reports will allow you to easily work with data across a number of worksheets, even in different workbooks, to create consolidated views of projects, tasks, events, deals, milestones, etc., that updates in real time for all stakeholders.
Gantt Chart View and Project Management Improvements We're serious about project management and have a whole set of Gantt chart view and project management improvements coming soon ranging from entirely rewritten task dependency algorithms to support for all of the standard dependency types (FS, SF, FF, and SS), constraint types, and lag times.
Row Movement We're adding the ability to drag and drop rows to reposition them in Sheet and Gantt views. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Drag & Drop Cell and Range Movement Similar to traditional spreadsheets, we're adding the ability to drag and drop individual cells and ranges to move them in the grid.
Mobile Apps A dedicated team of developers has been working hard on initial versions of the Spreadsheet.com iOS and Android mobile apps, with pinch zoom, touch gesture support for cells, and several other complex features that most of us take for granted in spreadsheet apps.
Stay tuned for these and more updates coming soon ...