Workflow Automation and AI Blog from Connex

Explore business process automation insights, expert tips, and real-world case studies. Learn how to automate workflows, integrate apps, and boost efficiency.

Posts

Scheduling form automation: Google Calendar + Trello + QuickBooks

Scheduling form automation: Google Calendar + Trello + QuickBooks

Oct 9, 2026

Build a scheduling form that creates Google Calendar events, Trello cards, and QuickBooks customers automatically, capturing customer info once, not 3 times.

Notion Workers: what they are + how to build and deploy one

Notion Workers: what they are + how to build and deploy one

Oct 9, 2026

Learn what Notion workers are, when to use them, and how to build, secure, deploy, and estimate cost for a worker on Notion’s developer platform.

Notion + Microsoft 365 for estate operations: Phase 1 blueprint

Notion + Microsoft 365 for estate operations: Phase 1 blueprint

Oct 9, 2026

Build an estate operations platform in Notion + Microsoft 365. Use phased workflows for SOPs, work orders, reporting, and (later) QuickBooks and Power Automate.

Harvest project setup for Hive clients (time tracking)

Harvest project setup for Hive clients (time tracking)

Oct 9, 2026

Set up one Harvest project per Hive client, assign consultants, and set billable rates so time tracking works and every engagement shows up on timesheets.

Fix Smokeball→Outlook contact dedup and updates

Fix Smokeball→Outlook contact dedup and updates

Oct 9, 2026

Fix Smokeball Outlook contact sync deduplication with fallback matching (email, then name, then phone) so updates hit existing contacts instead of duplicates.

Fix Missing Zoom Meeting IDs in Automation Pipelines

Fix Missing Zoom Meeting IDs in Automation Pipelines

Oct 9, 2026

Fix missing Zoom meeting IDs in automation pipelines with a root-cause checklist, logging, backfill steps, and guardrails to prevent silent failures.

Automate OneDrive Excel loads to SQL Server with Power Automate

Automate OneDrive Excel loads to SQL Server with Power Automate

Oct 9, 2026

A Power Automate checklist for ingesting quarterly Excel files from OneDrive into SQL Server, with validation, upserts, run logging, and safe reruns.

When Ringba annotations go missing: a webhook debug guide

When Ringba annotations go missing: a webhook debug guide

Oct 9, 2026

Ringba annotations missing? Follow this step-by-step debug flow across Ringba, Pabbly, and Pipedream to find gaps, fix filters, and prevent repeats.

Microsoft 365 nonprofit scheduling automation (intake + waitlists)

Microsoft 365 nonprofit scheduling automation (intake + waitlists)

Oct 9, 2026

Microsoft 365 nonprofit scheduling automation: connect intake, eligibility review, self-scheduling, waitlists, SMS reminders, and RBAC on one Microsoft stack.

How to Automatically Find Broken Links and Missing Images

How to Automatically Find Broken Links and Missing Images

Oct 9, 2026

Build an automated crawler that finds broken links and missing images, logs each issue to Notion, and routes fixes to an owner, so you skip the manual audits.

Fix Facebook Lead Ads to Jobber in Zapier (No Duplicates)

Fix Facebook Lead Ads to Jobber in Zapier (No Duplicates)

Oct 9, 2026

Fix missing fields and duplicates when sending Facebook Lead Ads to Jobber via Zapier. Learn mapping, dedupe, and update flows to stop manual data entry.

BambooHR to CSI payroll integration: one-way sync + timing

BambooHR to CSI payroll integration: one-way sync + timing

Oct 9, 2026

Plan a BambooHR to CSI payroll integration with a one-way sync, scheduled runs + manual push, and effective-dated changes that land in the right pay period.