n8n Engineer: Multi-App Business Suite, Paid Ads, Content Approval & Daily Reporting

Here is your finalized, complete job post ready to copy and paste directly into Upwork: Job Title: Senior n8n Engineer: Multi-App Business Suite, Paid Ads, Content Approval & Daily Reporting Project Overview We are seeking a Senior n8n Automation Engineer to design, build, and document an enterprise-grade automation pipeline connecting 12 core platforms. The ecosystem will handle interactive mobile approval workflows with rich previews, paid ad metric logging into Excel, cross-platform messaging, and automated daily reporting. Core Workflow Pillars 1. Interactive Mobile Approvals, Rich Previews & Task Audits Content Previews & Asana Audits: Pull task data from Asana to generate a rich preview of social posts (including image thumbnails and full copy). Automatically audit the Asana task before sending the alert, displaying a red/yellow warning banner inside the notification if required fields, tags, or media attachments are missing. Interactive Mobile Buttons & SMS Fallback: Send approval requests via Slack Block Kit or Telegram Bot requiring a single tap to publish or reject. Include an automated 5-minute fallback to Twilio SMS if mobile data connection drops or the push notification goes unacknowledged. Smart Message Drafting: Generate suggested responses for incoming client inquiries (Gmail, Slack, Social DMs) with rich previews for mobile review. No response is ever sent automatically without manual click-approval or editing. 2. Central Database Sync (Microsoft Excel / OneDrive) Paid Advertising Metrics: Automatically aggregate and log daily/weekly campaign performance metrics (spend, clicks, impressions, conversions) from Meta Ads, LinkedIn Ads, and Google Ads into structured Excel sheets. Storage, Media & Tasks: Log new Google Drive uploads, YouTube podcast publications, and Asana task status changes in real time. 3. Automated Daily Reporting & Failover Alerts Daily Multi-Platform Summary: Aggregate daily performance, lead stats, and task activity across all 12 platforms into a single, clean daily report delivered via Slack or Email. Urgent Alerts: Route high-value workspace events and urgent client inquiries straight to your phone with failover notification logic. Required Deliverables Production Workflows: Fully functional, active canvas nodes running on our n8n Cloud instance. Guided Security Setup: A live screen-share session to input sensitive API credentials (Google Ads Developer Tokens, Meta/LinkedIn OAuth, Twilio) securely without sharing primary passwords. Loom Video & Documentation: A step-by-step video guide covering workflow maintenance, token refresh procedures, and instructions for adding extra social accounts in the future.