Google Drive and MySQL integration

AI-Powered Tech Radar Advisor This project is built on top of the famous open source ThoughtWorks Tech Radar. You can use this template to build your own AI-Powered Tech Radar Advisor for your company or group of companies. Target Audience This template is perfect for: Tech Audit & Governance Leaders:** Those seeking to build a tech landscape AI platform portal. Tech Leaders & Architects:** Those aiming to provide modern AI platforms that help others understand the rationale behind strategic technology adoption. Product Managers:** Professionals looking to align product innovation with the company's current tech trends. IT & Engineering Teams:** Teams that need to aggregate, analyze, and visualize technology data from multiple sources efficiently. Digital Transformation Experts:** Innovators aiming to leverage AI for actionable insights and strategic recommendations. Data Analysts & Scientists:** Individuals who want to combine structured SQL analysis with advanced semantic search using vector databases. Developers:** Those interested in integrating RAG chatbot functionality with conversation storage. Description Tech Constellation is an AI-powered Tech Radar solution designed to help organizations visualize and steer their technology adoption strategy. It seamlessly ingests data from a Tech Radar Google Sheet—converting it into both a MySQL database and a vector index—to consolidate your tech landscape in one place. The platform integrates an interactive AI chat interface powered by four specialized agents: AI Agent Router:** Analyzes and routes user queries to the most suitable processing agent. SQL Agent:** Executes precise SQL queries on structured data. RAG Agent:** Leverages semantic, vector-based search for in-depth insights. Output Guardrail Agent:** Validates responses to ensure they remain on-topic and accurate. This powerful template is perfect for technology leaders, product managers, engineering teams, and digital transformation experts looking to make data-driven decisions aligned with strategic initiatives across groups of parent-child companies. Features Data Ingestion A Google Sheet containing tech radar data is used as the primary source. The data is ingested and converted into a MySQL database. Simultaneously, the data is indexed into a vector database for semantic (vector-based) search. Interactive AI Chat Chat Integration:** An AI-powered chat interface allows users to ask questions about the tech radar. Customizable AI Agents:** AI Agent Router: Determines the query type and routes it to the appropriate agent. SQL Agent: Processes queries using SQL on structured data. RAG Agent: Performs vector-based searches on document-like data. Output Guardrail Agent: Validates queries and ensures that the responses remain on-topic and accurate. Usage Examples Tell me, is TechnologyABC adopted or on hold, and why? List all the tools that are considered part of the strategic direction for company3 but are not adopted. Project Links & Additional Details GitHub Repository (Frontend Interface Source Code):** github.com/dragonjump/techconstellation Try It:** https://scaler.my

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 and submitted nominations, stores the data in a MySQL database, and generates a report of all nominations. The report is then exported as a CSV file and can be automatically shared via Google Drive and Slack. Key features Authenticates with App Store Connect using JWT. Fetches all apps and submitted nominations, including details and related in-app events (API documentation: https://developer.apple.com/documentation/appstoreconnectapi/featuring-nominations) Stores and updates app and nomination data in MySQL tables. Generates a comprehensive nominations report with app and nomination details. Exports the report as a CSV file. Shares the report automatically to Google Drive and Slack. Runs on a weekly schedule, but can be triggered manually as well. Setup Instructions Obtain your App Store Connect API credentials (Issuer ID, Key ID, and private key) from your Apple Developer account. Set up a MySQL database and configure the connection details in the workflow’s MySQL node(s). (Optional) Connect your Google Drive and Slack accounts using the respective n8n nodes if you want to share the report automatically. Update any credentials in the workflow to match your setup. Activate the workflow and set the schedule as needed. This template is ideal for teams who regularly submit apps or updates for featuring on the App Store and want to keep track of their nomination history and status in a structured, automated way.

📝 Compliance Report Collector (Google Form → Drive + MySQL) This n8n workflow automates the collection and archival of compliance reports submitted via Google Forms. Uploaded documents (PDF, DOCX, etc.) are archived into Google Drive and submission metadata is logged into a MySQL database. It ensures compliance documentation is properly stored, searchable and auditable without manual effort. ⚡ Quick Implementation Steps Import the JSON file into n8n. Set up a Google Form to POST file + metadata (reporter, category, etc.) to the /submit-report webhook. Update the Set Config node with your: MySQL connection details Google Drive folder ID Deploy and test a form submission with a file upload. Each report is stored in Drive and logged to your DB. 🎯 Who’s It For Compliance officers handling environmental or safety reports. Admins managing documentation for inspections. Renewable energy companies required to maintain audit-ready records. Any org needing structured report archival & metadata logging. 🛠 Requirements | Tool | Purpose | |------|---------| | n8n Instance | Workflow automation | | Google Drive | To archive uploaded reports | | MySQL Database | To log submission metadata | | Google Forms / HTML Form | Report submission source | 🧠 What It Does Listens for incoming POST requests with a file and metadata. Uploads the file to a specified Google Drive folder. Extracts metadata like: Reporter name Category/type Timestamp File name, MIME type Logs that metadata into a MySQL table for auditing or reporting. 🧾 Sample MySQL Table Schema CREATE TABLE report_logs ( id INT AUTO_INCREMENT PRIMARY KEY, reporter VARCHAR(100), category VARCHAR(100), timestamp DATETIME, file_name VARCHAR(255), mime_type VARCHAR(50), folder_id VARCHAR(100) ); 🔧 How To Set Up – Step-by-Step Import the JSON into n8n. Configure the following in the Set Config node: MySQL: dbHost, dbUser, dbPassword, dbName, dbTable Google Drive: driveFolderId Update the webhook URL in your Google Form (via Apps Script or middleware). Test submission with a file upload. Confirm: File lands in your Drive folder Log entry appears in your database ✨ How To Customize | Customization | How | |---------------|-----| | Add more form fields | Extend the metadata mapping in the Function node | | Rename files before upload | Modify filename in Google Drive node | | Add email confirmation | Add an Email Send node after DB insert | | Filter file types | Add IF node before upload to validate MIME type | ➕ Add‑ons (Optional Extensions) | Add-on | Description | |--------|-------------| | 📤 Email Acknowledgment | Email sender a confirmation with Drive link | | 🧾 PDF Parser | Auto-parse content using PDF.co or OpenAI | | 📊 Admin Dashboard | Display logs in Supabase or Metabase | | 🗃 File Backup | Copy files to Dropbox or S3 after Drive upload | 📈 Use Case Examples Collect monthly safety audits from plant staff into a Drive archive. Accept vendor compliance declarations via Google Form and auto-log to DB. Capture field inspection reports and tag by category for audit. Store weekly environmental reports for long-term access. 🧯 Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | File not uploaded | Drive ID is invalid | Check permissions and folder ID | | DB not logging | Connection or table issue | Verify DB credentials and schema | | Webhook not triggered | Form not integrated correctly | Ensure form POSTs file to n8n webhook | | Wrong file type | MIME mismatch | Validate acceptable types via Function/IF node | 📞 Need Help? Want to integrate this with audit dashboards or add Google Sheet exports? 👉 Contact WeblineIndia — Experts in compliance automation and renewable energy workflows.