Extract text from a PDF file
Companion workflow for Read PDF node docs
By amudhanAutomate social media content creation & publishing with AI & human approval flow
β What problem does this workflow solve? Managing content for multiple social media platforms manually is time-consuming and error-prone. This workflow automates content creation, image generation, approval flows, and publishing for LinkedIn, Twitter (X), and Instagram using AIβwhile still keeping human oversight in place. --- π‘ Main Use Cases π Automatically generate AI-powered social media content and images. π§ Create platform-specific posts for LinkedIn, Twitter (X), and Instagram. β Route each post through human approvalsβfirst for prompt, then for final content. π€ Publish approved posts to all platforms seamlessly. π Maintain an audit trail with all steps logged in Google Sheets. --- π§ How It Works β Step-by-Step βοΈ Topic Input A new topic and description is added to a Google Sheet. A scheduled trigger starts the automation at regular intervals (daily, weekly, etc.). π§ AI-Powered Prompt Generation AI generates tailored prompts for each platform: LinkedIn Twitter (X) Instagram Prompts are logged in the sheet and paused for human approval. πΌοΈ Content + Image Creation (Post Drafts) Once approved, the workflow: Uses AI to write full post captions Generates platform-specific images (via DALLΒ·E, Stable Diffusion, or other AI image tools) Draft content is stored in Google Sheets. π§βπ» Final Content Approval Posts pause again for final manual approval. If approved β move to publishing. If rejected β status updated in the sheet, post is skipped. π€ Auto-Publishing to Social Platforms Approved content is published automatically: β LinkedIn β via LinkedIn API π¦ Twitter (X) β post text + media via Twitter API πΈ Instagram β via Meta Graph API (image + caption) π Logging & Reporting Google Sheets is updated with: Final post text Approval timestamps Post URLs Status (Posted / Rejected) --- π§ Tools & Integrations Used OpenAI / GPT-4 β for prompt and content generation AI Image Generator β DALLΒ·E, Replicate, etc. Google Sheets β as the central control + approval hub LinkedIn API Twitter API (X) Instagram Graph API n8n Scheduler, If Nodes, and Pauses β to handle flow control & approvals --- π€ Who can use this? This is perfect for: π’ Marketing teams π§βπΌ Solo founders managing content π§ Agencies offering social media management βοΈ Ops teams building internal automation Whether you're managing 3 posts a week or 30, this system keeps your content AI-powered and human-approvedβon autopilot. --- π Customization Ideas Add Slack or email alerts for approval stages Pull trending topics using a news API or Twitter Trends Add a weekly content summary report sent via email Expand to Facebook, Threads, or Pinterest --- π Ready to Launch? Just configure: β Google Sheet with topic list & approval columns β API credentials for LinkedIn, Twitter, and Instagram β OpenAI and image generation API keys β¦and your fully automated, human-approved social content engine is ready to go!
By InfyOm TechnologiesGenerate personalized and aggregate survey reports with Jotform and Gemini AI
Generate Personalized & Aggregate Survey Reports with Jotform and Gemini AI Overview Automatically transform Jotform survey responses into intelligent, professional reports. This workflow generates personalized insights for each respondent and statistical summaries for administrator, all hands-free. Who Should Use This Survey managers needing automated report generation Market researchers analyzing response data Product teams collecting customer feedback Organizations using Jotform without built-in analytics What It Does Two-Part Report System: Personal Reports (Instant) Triggers immediately when respondent submits survey AI analyzes their individual responses using Google Gemini Generates customized insights and recommendations Sends professional HTML report to respondent's email Weekly Aggregate Reports (Scheduled) Runs automatically every week Collects all survey submissions Calculates statistics, percentages, and trends Identifies patterns across all respondents Sends comprehensive analysis to admin Key Features β Real-time personal report generation β Intelligent AI-powered analysis (Google Gemini) β Professional HTML email formatting β Automatic weekly summaries β Statistical analysis and trend identification β Zero manual processing required β Fully customizable prompts and styling β Works with any Jotform survey structure Setup Requirements Jotform account with active survey form Get Jotform from here n8n instance (cloud or self-hosted) Google Gemini API key Gmail account (for sending reports) Jotform API key What You Get in Reports Personal Reports Include: Respondent Profile β Auto-extracted demographics (age, role, location, email) Key Insights β 3-4 AI-generated insights specific to their responses Personalized Recommendations β 3-4 actionable suggestions based on their answers Professional Formatting β HTML-styled email with your branding colors Mobile Responsive β Looks great on all devices Fully Customizable: Edit the AI prompt to generate different types of insights Change HTML styling (colors, fonts, layout) Add/remove sections (logos, footers, additional analysis) Adjust the tone (professional, casual, technical, etc.) Include custom branding and messaging Aggregate Reports Include: Total Respondents Count β How many submissions in the period Demographic Breakdown β Distribution of respondent profiles Response Statistics β Percentages and frequencies for each question Answer Distribution β Most popular choices across all responses Trend Analysis β Patterns and correlations in the data Key Findings β Top 5-7 insights from all responses combined Statistical Metrics β Averages, frequencies, comparisons Fully Customizable: Choose which statistics to calculate and display Change how data is visualized and presented Customize report styling and branding Adjust analysis depth and metrics focus Add custom sections for your specific needs Modify HTML layout and design How Reports Look Personal Report Structure (Email): Header: Professional gradient background with thank you message Section 1: Respondent Details (extracted from survey) Section 2: Key Insights (AI-generated from their responses) Section 3: Recommendations (personalized suggestions) Footer: Thank you message and company info Aggregate Report Structure (Email): Header: Report title and date range Section 1: Total respondent count and demographics Section 2: Question-by-question response breakdown Section 3: Statistical analysis and trends Section 4: Key findings and patterns discovered Section 5: Actionable insights for decision-makers Footer: Next report date and company branding Quick Start Get your Jotform Form ID and API key Enable Google Gemini API and create API key Set up Gmail OAuth2 credentials in n8n Import this workflow Add your credentials to the nodes Test with a sample survey submission Complete setup instructions are included in the workflow as an expandable sticky note. Workflow Logic PERSONAL REPORTS: Survey Submission β Collect Response Data β AI Analysis & Insights Generation β Create Styled HTML Report β Send to Respondent Email AGGREGATE REPORTS: Weekly Schedule Triggers β Fetch All Submissions β Statistical Analysis & Trend Detection β Generate Insights from All Data β Create Summary HTML Report β Send to Admin Email Use Cases Customer Feedback Surveys β Analyze responses, send personalized insights Product Research β Track trends across respondents weekly Market Research β Automated statistical reporting Employee Surveys β Personalized feedback + company trends Event Feedback β Instant attendee insights + organizer summary Customer Satisfaction (NPS) β Personalized follow-ups + trend analysis Lead Qualification β Auto-analyze prospect responses and route accordingly
By Roshan Ramani