Templates / Track and report App Store featuring nominations with MySQL, Slack and Google Drive

Track and report App Store featuring nominations with MySQL, Slack and Google Drive

Ready for 3.0

by Ertay Kaya ✓ · 81 views · created 2025-12-16 · Document Extraction

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 12 nodes and runs on a schedule (every 7 days at 10:00). Along the way it connects Google Drive, Slack, JWT and MySQL. It also calls api.appstoreconnect.apple.com over HTTP.

How it runs

Trigger: On a schedule (every 7 days at 10:00).

  1. JWT: uses JWT
  2. Generate the report with a query (MySQL): run a query
  3. Fetch submitted nominations from App Store Connect (HTTP Request): calls api.appstoreconnect.apple.com
  4. Fetch apps from App Store Connect (HTTP Request): calls api.appstoreconnect.apple.com
  5. Convert to File: converts data to a file
  6. Split Out: splits a list into separate items
  7. Split Out: splits a list into separate items
  8. Upload file (Google Drive): uses Google Drive
  9. Upload a file (Slack): work with file
  10. Store nominations in MySQL (MySQL): create or update

…plus 1 more step. See the full node list below.

Services it uses

Google DriveSlackJWTMySQL

HTTP calls to: api.appstoreconnect.apple.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

Apple App Store Connect: Featuring Nominations Report This workflow automates the process of tracking and reporting app nominations submitted to Apple for App Store featuring consideration. It connects to the App Store Connect API to fetch your list of apps…

Excerpt from Ertay Kaya's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.