LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Defining the Trigger
  • Configuring the Trigger in Zapier

Was this helpful?

  1. Connections

Zapier Trigger

This article describes the Zapier Trigger connector and its properties.

PreviousDatabase ConnectionsNextOverview

Last updated 1 year ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans have access to the Zapier Trigger connector.

For more details, see our .

Zapier is a no-code tool that integrates web applications. Within Zapier you create “Zaps” that connect your applications. There are two main components of a Zap. A trigger and an Action.

The Trigger is what starts the Zap. This tells the Zap to run and provides data to the Zap. The Action is what Zapier does with the data inside the Zap. For example, sending the data to another web application or system.

The Squirrel Zapier trigger connection allows you to trigger a Zap from your Squirrel project.

For example, if you have a calculator in Squirrel where a prospective customer has entered some values to generate a quote. Squirrel could send this data to Zapier where it automatically updates your CRM and sends you an email, or a text message.

To add a Zapier trigger connection to your project open the CONNECTIONS drawer in the object browser, select the “Zapier Trigger” entry from the dropdown box, and click the plus button:

The connection will appear in the CONNECTIONS drawer of the Object Browser. Select it to access its properties in the property panel.

Defining the Trigger

DEFINITION

To start the definition of the connection the data which will be sent to the Zap must be specified:

This will be a range with either two rows and several columns or 2 columns and several rows. For example, if the data to be sent was about two new orders and included the order number for each, the product ordered, the number of units, and the total sale value then these could be sent in either of the following two ranges:

When the trigger fires the data will be passed to Zapier which will trigger the Zap once for each row/column of data.

Once the data has been specified more properties appear:

Data is in … – this specifies whether the data specified is in rows or columns, choose the one that matches the data specified

  • Includes header row – it is strongly recommended to have a header row/column in your data (as shown in the data example above) as this will make specifying the details of your Zap in Zapier significantly easier. If there is no header row/column in the data then this option should be unchecked and Squirrel will add headers of Item1, Item2, etc.

  • Ignore blank rows – when this option is checked, Squirrel will remove blank data from the end of the range when sending the data to Zapier.

  • Give your trigger a name – this property is used to give your trigger a meaningful name, this name is passed to Zapier and can be used to manage your triggers via the Squirrel 365 cloud.

Once all these properties are specified, click the “Register Trigger” button to register the trigger with the Squirrel365 cloud.

Once the trigger has been registered a Zap key is displayed. This key will be used to uniquely identify the trigger with Zapier. The copy button will place the Zap Key in your clipboard, you will need it later when setting up your Zap in Zapier.

TRIGGER ZAP WHEN…

  • Project loads – If this option is checked the Zap will be triggered as soon as the Squirrel project has been loaded.

  • Cell changes – If this option is checked then a cell in the spreadsheet needs to be specified and the Zap will trigger when the value in that cell changes.

  • Cell Equals – If this option is checked when the value in a cell equals a particular value

    • When cell – this property must be bound to a single cell in the spreadsheet

    • Equals – this gives the value against which the cell value is tested, it can either be bound to a single cell in the spreadsheet or specified directly in the property box.

Configuring the Trigger in Zapier

In Zapier create a new Zap and select the Squirrel365 app and trigger event.

This is an “instant” trigger which means that as soon as Squirrel sends the data to Zapier, the Zap workflow is instantly executed.

Click Continue and in the next screen paste in the Zap key copied from the trigger connection’s property sheet (above) and click continue

The next step will be to test the trigger. When you press the “Test trigger” button, Zapier will communicate with the Squirrel365 cloud and get the sample data saved as part of the registration process above.

Once you’ve got the sample data you will be able to continue configuring Zapier to connect to any of the many actions available across a wide variety of web apps.

pricing comparison matrix