Automate Japanese Gig Emails with n8n & Google Tools

Effortlessly Streamline Your Japanese Gig Emails with n8n & Google Tools

Unlock the power of automation with this expertly designed n8n workflow that seamlessly handles Japanese gig inquiries in your Gmail. Watch as it smartly flags risks, employs Google Gemini to analyze details and score requests, logs opportunities in Google Sheets, and crafts tailored replies swiftly. For accepted gigs, this workflow even sets up Google Drive folders and Google Docs templates while marking your calendar — all hassle-free!

What this workflow does

• Automatically triggers every minute to scan for new Japanese gig inquiries in Gmail.
• Cleanses and normalizes emails, identifies source platforms, and scans for red-flag keywords to assign an initial risk score.
• Utilizes Google Gemini to extract project details, assess risks, and draft replies in Japanese.
• Evaluates scores to decide whether to accept, hold, or decline requests while calculating the minimum acceptable price.
• Logs each gig opportunity, including scores and draft responses, into a Google Sheets tracking system.
• Generates Gmail drafts for clarifications or polite declines, ensuring personalized communication.
• For accepted projects, creates a Google Drive folder, generates essential Docs templates, and schedules a preliminary Google Calendar entry.

Use cases

• Freelancers managing multiple Japanese gig requests can streamline their inbox to focus on viable projects.
• Automation engineers and SaaS operators wanting to integrate an efficient gig inquiry management system.
• n8n users looking to leverage Google tools to enhance productivity in managing side gigs.

Technical details

• Integrations: Gmail, Google Gemini, Google Sheets, Google Drive, Google Docs, Google Calendar.
• Nodes used: set, code, gmail, switch, google docs, sticky note.