Track and report App Store featuring nominations with MySQL, Slack and Google Drive
Ready for 3.0What 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).
- JWT: uses JWT
- Generate the report with a query (MySQL): run a query
- Fetch submitted nominations from App Store Connect (HTTP Request): calls api.appstoreconnect.apple.com
- Fetch apps from App Store Connect (HTTP Request): calls api.appstoreconnect.apple.com
- Convert to File: converts data to a file
- Split Out: splits a list into separate items
- Split Out: splits a list into separate items
- Upload file (Google Drive): uses Google Drive
- Upload a file (Slack): work with file
- Store nominations in MySQL (MySQL): create or update
…plus 1 more step. See the full node list below.
Services it uses
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)
- Convert to File
n8n-nodes-base.convertToFile - Split Out
n8n-nodes-base.splitOut - Google Drive
n8n-nodes-base.googleDrive - Slack
n8n-nodes-base.slack - JWT
n8n-nodes-base.jwt - HTTP Request
n8n-nodes-base.httpRequest - MySQL
n8n-nodes-base.mySql - Schedule Trigger
n8n-nodes-base.scheduleTrigger
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…