The method
Use these prompts with a large language model like ChatGPT. Provide context about your automation goal and desired triggers/actions in n8n. Tailor the prompts to your specific use case for the best results. Refine as needed.
The prompts
Prompt 1
Design an n8n workflow that automatically saves new tweets mentioning a specific keyword into a Google Sheet. The workflow should trigger when a new tweet matches the keyword, extract the tweet text and author, and append this information to a specified Google Sheet. Detail each node required, the configurations needed for each node (including authentication methods where applicable), and how to handle potential errors such as API rate limits. Also, provide instructions for setting up the necessary credentials and permissions within both Twitter's developer platform and Google Cloud Platform.
Prompt 2
Create an n8n workflow to synchronize new customer data between a PostgreSQL database and a Salesforce account. The workflow should trigger whenever a new customer is added to the PostgreSQL database. It should then extract relevant customer information (e.g., name, email, address) and create a corresponding new lead in Salesforce. Explain how to configure the database connection, map the data fields correctly between PostgreSQL and Salesforce, handle data type conversions, and address potential issues like duplicate entries or failed API requests. Include details on securely managing database credentials and Salesforce API keys within n8n.
Prompt 3
Develop an n8n workflow that monitors a specific folder in Google Drive for new files. When a new file is added, the workflow should automatically upload the file to an Amazon S3 bucket, send a notification to a Slack channel with the file name and a link to the S3 location, and then delete the original file from Google Drive. Detail the necessary steps for authenticating with Google Drive, Amazon S3, and Slack within n8n. Provide guidance on configuring file size limits, error handling for upload failures, and managing access permissions on both Google Drive and S3. Describe strategies for efficiently handling large files and minimizing storage costs.
Prompt 4
I need an n8n workflow that sends automated email reminders to users 3 days before their subscription expires. The workflow should retrieve a list of users and their subscription expiry dates from a MySQL database. For each user whose expiry date is within 3 days, it should send a personalized email using SendGrid, reminding them to renew their subscription. Explain how to connect to the MySQL database, query for the relevant user data, format the email content with personalized details, and configure SendGrid for sending emails. Include error handling for database connection issues and email delivery failures. Suggest a method to prevent duplicate reminders if the workflow runs multiple times.
Prompt 5
Generate an n8n workflow to automate the process of creating invoices in Xero from new orders received in a WooCommerce store. The workflow should trigger when a new order is placed in WooCommerce. It should then extract the order details (e.g., customer information, items ordered, total amount) and create a corresponding invoice in Xero. Detail the configuration needed for connecting to both WooCommerce and Xero, mapping the order data to invoice fields, and handling potential errors such as invalid product codes or customer information discrepancies. Provide instructions on securely managing API keys for WooCommerce and Xero within n8n, and suggest strategies for managing taxes and discounts in the invoice creation process.