Generate portfolio screenshots and Upwork copy with Firecrawl, ScreenshotOne, OpenAI and Google Workspace β€” n8n Workflow

High complexity⚑ Trigger17 nodesπŸ‘©β€πŸ’» IT OpsπŸ‘ 1 viewsby Valeriy Halahan

Overview

AI Portfolio Generator for Freelancers

Automatically transform any website URL into a complete portfolio entry with professional screenshots and AI-generated Upwork project descriptions.

🎯 Perfect For

Freelancers** building their Upwork/portfolio from past projects Agencies** documenting client work at scale Web developers** showcasing their websites professionally Anyone** who needs consistent, high-quality website screenshots

✨ What It Does

Submit a URL via simple web form AI analyzes the

Nodes used

Google SheetsHTTP RequestTelegramGoogle DriveCode

Workflow Preview

πŸ“‹ Portfolio Screenshot Generator - Setup Gui
What this workflow does:
1. Takes a website URL from a form
2. Renders the page with JavaScript (Firecrawl)
3. AI analyzes the site structure and c
πŸ”‘ STEP 1: Firecrawl API Key
What: Firecrawl renders JavaScript pages
How to get:
1. Go to https://firecrawl.dev
2. Sign up / Log in
3. Get your API key
πŸ”‘ STEP 2: ScreenshotOne API Key
What: Takes high-quality screenshots
How to get:
1. Go to https://screenshotone.com
2. Sign up (free tier available)
3. Copy your Access Key
πŸ”‘ STEP 3: OpenAI Credentials
What: AI analyzes sites & writes Upwork descriptions
Setup:
1. Go to Settings β†’ Credentials
2. Add new "OpenAI API" credential
3. Paste your API key from:
πŸ“ STEP 4: Google Drive Setup
What: Stores screenshot images
Setup OAuth:
1. Settings β†’ Credentials β†’ Add "Google Drive OAuth2"
2. Follow OAuth flow
⚠️ CHANGE FOLDER ID:
πŸ“Š STEP 5: Google Sheets Setup
What: Logs all results in a spreadsheet
Setup OAuth:
1. Settings β†’ Credentials β†’ Add "Google Sheets OAuth2"
2. Follow OAuth flow
⚠️ CHANGE DOCUMENT ID:
πŸ“± STEP 6: Telegram Setup
What: Sends notification when done
Setup Bot:
1. Message @BotFather on Telegram
2. Send /newbot and follow steps
3. Copy the bot token
🎨 CUSTOMIZATION OPTIONS
Screenshot Settings (Site Configuration node):
- `viewport_width`: 1920 (desktop) / 375 (mobile)
- `device_scale_factor`: 2 (retina quality)
- `delay`: 3 seconds (wait
πŸ”„ WORKFLOW FLOW
```
Form β†’ Firecrawl β†’ AI Analysis β†’ Screenshots β†’ Upload β†’
```
Loop Logic:
Screenshots are processed one-by-one with 3s delay to a
πŸš€ TRIGGER
Form URL:
After activating, get the form URL from this node.
Share this URL to allow others to submit websites for p
Site Configuration
Take Screenshot
Merge Screenshot Data
Upload to Google Drive
Aggregate All Results
Save to Google Sheets
Telegram Notification
Firecrawl Scrape
Parse AI Response
Prepare AI Request
AI Site Analysis
Prepare Upwork Request
AI Generate Upwork
Parse Upwork Response
⚑
P
Portfolio Form
L
Loop Over Items
W
Wait 3s
17 nodes17 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 17 nodes, connecting code, formtrigger, googledrive.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (17)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
TE

Telegram

telegram

#3
GO

Google Drive

googleDrive

#4
CO

Code

code

#5

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows β†’ New β†’ Import from file.
  3. 3Select the downloaded generate-portfolio-screenshots-and-upwork-copy-with-firecrawl-screenshotone-openai-and-google-workspace file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n β†’ Import from JSON:

{ "name": "Generate portfolio screenshots and Upwork copy with Firecrawl, ScreenshotOne, OpenAI and Google Workspace", "nodes": [...], ...}

Integrations

codeformtriggergoogledrivegooglesheetshttprequestsplitinbatchestelegramwait

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes17
Complexityhigh
Triggertrigger
Views1
CategoryIT Ops

Created by

Valeriy Halahan

Valeriy Halahan

@loomreach

Tags

codeformtriggergoogledrivegooglesheetshttprequestsplitinbatchestelegramwait
⚑

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free β†’

Related IT Ops Workflows

GMGOIFOP+2
medium

AI Third-Party Risk Assessment & Vendor Onboarding in n8n

Manual vendor risk assessments are a bottleneck for modern compliance teams. This automated workflow streamlines the entire Third-Party Risk Management (TPRM) lifecycle by integrating AI intelligence with your existing tech stack. The process triggers via a Webhook (such as a form submission), where OpenAI analyzes vendor documentation, data access levels, and security certifications to determine an objective risk tier. By applying logic-based filtering, the flow automatically categorizes vendors into Low, Standard, or Critical risk profiles. It then logs all due diligence data into Google Sheets for a permanent audit trail and sends personalized status notifications via Gmail to procurement stakeholders. This eliminates manual data entry and ensures that every vendor undergoes the same rigorous scrutiny. Whether you are preparing for a SOC2 audit or managing a growing supply chain, this automation provides a scalable, traceable, and AI-enhanced framework for governance, risk, and compliance (GRC) without the overhead of expensive enterprise software. **Common Use Cases:** - Automated SOC2/ISO 27001 evidence gathering for vendor audits - High-speed security screening for SaaS procurement requests - Continuous supply chain monitoring and risk tiering database

πŸ”— WebhookΒ·6 nodes
GMGOOPSW+1
medium

AI Lead Nurturing & Routing for FinTech (n8n & OpenAI)

Transform your financial services firm into a high-conversion machine with this automated lead management framework. This n8n workflow eliminates the friction of manual data entry and generic follow-ups by leveraging OpenAI to generate hyper-personalized email responses based on specific prospect intent. Whether you are managing credit repair inquiries or insurance applications, the system acts as an intelligent virtual assistant that categorizes incoming webhooks in real-time. The process begins when a lead is captured via your frontend (such as Lovable or a custom landing page). The workflow utilizes an advanced Switch logic to segment prospects into specialized funnelsβ€”Business Funding, Life Insurance, or Recruitment. OpenAI then analyzes the lead's unique profile to draft a context-aware email that addresses their specific pain points, which is automatically dispatched via Gmail. Simultaneously, all lead data and AI-generated insights are logged into Google Sheets, providing your sales team with a centralized, up-to-date CRM. This automation ensures a zero-latency response time, significantly increasing your chances of conversion while freeing your team from repetitive administrative tasks. **Common Use Cases:** - Automated qualification and personalized outreach for commercial loan applicants. - Dynamic recruitment funnels for scaling independent insurance agencies. - High-touch lead nurturing for credit restoration and financial consulting services.

πŸ”— WebhookΒ·14 nodes
@ACOGOGO+4
medium

Automate Amazon Review Sentiment Analysis with Gemini AI

Transform raw customer feedback into actionable product intelligence with this advanced n8n automation. This workflow eliminates the manual drudgery of sorting through thousands of Amazon reviews by leveraging the Apify scraper to extract high-intent data. Once retrieved, the data is processed through Google Gemini AI, which performs deep sentiment analysis to pinpoint recurring pain points and product defects. Unlike basic scrapers, this system categorizes negative feedback into root causes and generates strategic improvement suggestions to help brands regain their competitive edge. The final insights are systematically logged into Google Sheets and pushed to Slack, ensuring your product development and customer success teams receive real-time alerts on critical issues. By automating this loop, businesses can drastically reduce response times to market trends and improve their Amazon Best Seller Rank (BSR) through data-driven product iterations. This is an essential tool for e-commerce managers and private label sellers looking to operationalize consumer insights without manual data entry. **Common Use Cases:** - Automated Product R&D for Private Label Sellers - Competitor Vulnerability Mapping and Market Research - Customer Experience Monitoring and Slack Alert System

⚑ Trigger·8 nodes
medium

AI-Driven School Allergy Safety & Menu Auditing via n8n

This advanced n8n workflow revolutionizes student safety by automating the critical task of dietary cross-referencing. By integrating Google Sheets with AI-powered analysis, the system eliminates human error in high-stakes cafeteria environments. The workflow functions as a proactive safety net: it ingests daily menu data and cross-references it against a centralized database of student allergy profiles and classroom rosters. Using LLM logic, it identifies hidden ingredients or cross-contamination risks that standard keyword searches might miss. When a conflict is detectedβ€”such as a gluten-sensitive student being scheduled for a meal containing wheatβ€”the system triggers an instant Slack notification to nutritionists and teachers. Beyond immediate alerts, the flow generates AI-suggested menu alternatives to ensure every student has a safe, nutritious meal option. This automation not only ensures strict compliance with health regulations but also saves administrative staff hours of manual spreadsheet auditing, allowing them to focus on meal quality rather than data entry. **Common Use Cases:** - Real-time dietary conflict alerting for school cafeterias - Automated ingredient cross-referencing for institutional catering - AI-powered meal substitution planning for healthcare facilities

▢️ ManualΒ·6 nodes
FUGOIFME+2
medium

Automate Inventory Tracking: Google Sheets & Slack (n8n)

Stop manual stock monitoring and prevent lost revenue with this automated Order Management System (OMS) template. This high-efficiency n8n workflow bridges the gap between your sales channels and warehouse operations. When a new order triggers the API webhook, the system instantly cross-references SKU data against your Google Sheets master inventory. By utilizing advanced logic and merge nodes, the workflow calculates availability in real-time. If stock levels are sufficient, it updates your records; if a shortage is detected, it sends an immediate, actionable alert to your team via Slack. This automation is designed for growing e-commerce businesses that need to eliminate human error in fulfillment. Instead of reactive firefighting when items sell out, your operations team can proactively manage supply chains. The flow handles complex data parsing through custom function nodes, ensuring that even multi-item orders are processed with precision, ultimately reducing operational overhead and improving the customer experience by preventing backorder frustrations. **Common Use Cases:** - E-commerce fulfillment automation for Shopify or WooCommerce stores using Google Sheets as a lightweight ERP. - Real-time low-stock alerting for high-volume hardware or electronics distributors to prevent supply chain bottlenecks. - Automated internal requisition tracking for large corporate offices managing hardware assets and office supplies.

πŸ”— WebhookΒ·13 nodes
COGOMAME+5
high

Automate GitHub Talent Sourcing to Google Sheets via n8n

Stop manual profile hunting and transform your technical recruitment with this high-performance n8n automation. This workflow leverages BrowserAct to perform deep-tissue scraping of GitHub user profiles, extracting mission-critical data pointsβ€”including repository history, tech stacks, and recent coding activityβ€”directly into structured Google Sheets reports. By automating the data enrichment phase, technical recruiters and HR teams can bypass hours of manual copy-pasting, ensuring a real-time database of pre-qualified developer talent. The flow operates by triggering a batch process that iterates through a list of GitHub handles, utilizing BrowserAct’s stealth scraping capabilities to bypass complex web barriers. Once the data is captured, a custom Code node cleans and formats the JSON output before merging it into a multi-tab Google Sheet for granular reporting. Finally, the workflow sends a summary notification via Slack to alert your team of new candidate insights. This is an essential blueprint for data-driven talent acquisition and competitive business intelligence, providing a seamless bridge between raw GitHub data and actionable recruitment pipelines. **Common Use Cases:** - Automated Technical Talent Mapping for Recruitment Agencies - Developer Outreach Enrichment for Open Source Project Growth - Competitive Intelligence and Tech Stack Analysis for BI Teams

⚑ Trigger·19 nodes