Turn a metrics request row into an Ayrshare report
Add a request to the sheet and receive the relevant post history automatically.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Get Post History
Tool to retrieve ayrshare post history with metrics. use when you need to fetch and filter past posts by date, status, or record count.
Why this helps
A metrics queue in Sheets still requires someone to perform each lookup manually.
- Clears reporting requests from a shared queue
- Keeps lookup scope explicit
- Returns results where your team already receives reports
Setup
Build it in a few focused steps.
- 1Connect Google Super and Ayrshare in Notis once.
- 2Create an automation that retrieves Ayrshare history for each new metrics request row.
- 3Pick New Rows in Google Sheet as the trigger.
- 4Choose a report channel and test with one request row.
Questions about this workflow
What should each request row include?
Include a campaign or post identifier and the desired dates, status, or record count.
Can Notis write results back to Sheets?
This workflow reports the retrieved history; it does not use a Sheets write action.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Ayrshare. A trigger fires from one place; an action lands in another.
Google Super triggers
Ayrshare actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Auto Schedule
Tool to create a new auto-post schedule with specified times and optional weekday filters. use when setting up recurring posting plans.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete a previously published Ayrshare post
Tool to delete an ayrshare post. use when you need to remove a published or scheduled post by its ayrshare post id, after confirming the correct id. note: instagram and tiktok published posts cannot be deleted via api; set `mark manual deleted=true` or remove manually.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Get Post History
Tool to retrieve ayrshare post history with metrics. use when you need to fetch and filter past posts by date, status, or record count.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Set Auto Schedule
Tool to set up an auto-post schedule with specified times and optional weekday filters. use when scheduling posts around a recurring pattern.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Connect any two apps with Notis in the middle.
Google Super and Ayrshare, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Ayrshare.