Classify Event Photos from Attendees with Gemma AI, Google Drive & Sheets — n8n 工作流

复杂度 触发器13 个节点🏷️ File Management作者:Jimleuk

概览

There's a clear need for an easier way to manage attendee photos from live events, as current processes for collecting, sharing, and categorizing them are inefficient.

n8n can indeed help to solve this challenge by providing the data input interface via its forms and orchestrate AI-powered classification of images using AI nodes. However, in some cases - say you run regular events or with high attendee counts - the volume of photos may result in unsustainably high inference fees (token usage ba

使用的节点

Edit ImageGoogle SheetsHTTP RequestGoogle Drive

工作流预览

1. Allow Guests to Upload via Form Trigger
Learn more about the form trigger
The form trigger is a quick and easy
2. Resize the Images for Faster Processing
Learn more about the Edit Image node
It's good practice to ensure we're o
3. Categorise Photos using Gemma Model via Fe
[Learn more about the Edit Image node](https://docs.n8n
5. Save Entry Into Google Sheets Table
Learn more about the Google Sheet node
Finally, each photo along with the
4. Store a Copy of the Photo in Google Drive
Learn more about the Edit Image node
For this demonstration, we'll use
Classify User-Uploaded Photos for Public Even
During or after in-person events, trying to collect and
![](https://cdn.subworkflow.ai/n8n-templates/
O
On form submission
F
Files to Items
G
Get File Meta
M
Merge
Classify Photo and Sugge…
E
Extract Categories
Upload file
Resize Image
Get Image Info
M
Merge1
C
Create Payload
C
Convert Image to Base64
Append to Sheet
13 nodes14 edges

工作原理

  1. 1

    触发器

    工作流由 触发器 触发器启动。

  2. 2

    处理

    数据流经 13 个节点, connecting editimage, extractfromfile, formtrigger。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (13)

ED

Edit Image

editImage

#1
GO

Google Sheets

googleSheets

#2
HT

HTTP Request

httpRequest

#3
GO

Google Drive

googleDrive

#4

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入
  3. 3选择下载的 classify-event-photos-from-attendees-with-gemma-ai-google-drive-sheets 文件并点击导入。
  4. 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
  5. 5点击 测试工作流 验证一切正常,然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴:

{ "name": "Classify Event Photos from Attendees with Gemma AI, Google Drive & Sheets", "nodes": [...], ...}

集成

editimageextractfromfileformtriggergoogledrivegooglesheetshttprequestmergesetsplitout

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点13
复杂度medium
触发器trigger

创建者

Jimleuk

Jimleuk

@jimleuk

标签

editimageextractfromfileformtriggergoogledrivegooglesheetshttprequestmergesetsplitout

n8n 新手?

n8n 是一款免费开源的工作流自动化工具,支持自托管或使用云版本。

免费获取 n8n →

Related File Management Workflows

COCOGOHT+5
medium

Sync SharePoint to Google Drive via Supabase (n8n Workflow)

Eliminate manual file transfers and data silos with this enterprise-grade synchronization pipeline. This n8n workflow automates the heavy lifting of mirroring your Microsoft SharePoint document libraries to Google Drive while maintaining a robust audit trail in Supabase or Postgres. Designed for high-reliability environments, the automation utilizes a sophisticated delta-check logic: it fetches SharePoint metadata, compares it against your existing database records using the 'Compare Datasets' node, and identifies only new or modified files for processing. By leveraging the 'Split in Batches' node, the system handles large volumes of data without hitting memory limits, ensuring every document is securely downloaded via HTTP and re-uploaded to its destination. Once the transfer is verified, the workflow updates your database status in real-time, providing a transparent log of your synchronization history. This is an essential solution for organizations transitioning between cloud ecosystems or those requiring a redundant, cross-platform backup strategy. It effectively bridges the gap between Microsoft and Google ecosystems using Supabase as a high-performance state-management layer. **Common Use Cases:** - Automated Multi-Cloud Disaster Recovery: Maintain a real-time mirror of critical SharePoint corporate assets in Google Drive to ensure business continuity during service outages. - Cross-Departmental Collaboration: Automatically sync project documentation from an executive SharePoint site to a creative team's Google Drive folder for seamless cross-platform access. - Centralized Document Auditing: Use Supabase to track every file movement between ecosystems, creating a searchable metadata index for compliance and regulatory reporting.

Scheduled·15 nodes
FOGOGOHT+2
medium

Automate Threads Video Backups to Google Drive & Sheets

Streamline your social media asset management with this robust n8n automation designed for digital marketers and content creators. This workflow eliminates the manual effort of downloading Threads content by providing a seamless bridge between Instagram's text-based platform and your cloud storage. Once triggered via a simple form input, the automation utilizes a RapidAPI connection to fetch high-quality video assets, processes the binary data, and securely uploads the file to a designated Google Drive folder. Simultaneously, the workflow maintains a centralized audit log in Google Sheets, capturing essential metadata such as timestamps and file IDs. Built-in logic gates and wait nodes ensure API rate limits are respected and file transfers are verified before logging. This is an essential tool for agencies managing high volumes of social content who need a reliable, automated pipeline for content repurposing, archival compliance, or collaborative review processes. By centralizing your Threads media assets, you ensure your creative team has instant access to raw footage without the friction of manual downloads. **Common Use Cases:** - Automated Social Media Content Archiving for Compliance - Centralized Asset Library Syncing for Creative Agencies - Competitor Research and Video Content Benchmarking

Trigger·9 nodes