Codez & AI
Building automations and AI agents for businesses
Templates by Codez & AI
Export WordPress posts to CSV and upload to Google Drive
Overview This n8n workflow automates the process of extracting published WordPress posts, converting them into a CSV file, and uploading it to Google Drive. It’s perfect for content backups, SEO audits, and data migration. Features Fetches all published posts from a WordPress website Extracts key post details (ID, Title, Link) Converts the extracted data into a CSV file Uploads the CSV file to Google Drive for easy access and storage Use Cases SEO Optimization: Export post data for keyword analysis and performance tracking Automated Content Backup: Store WordPress post details in Google Drive. You can add more fields to the Csv file if needed Workflow Steps Trigger Workflow Manually The workflow starts when triggered manually in n8n. Retrieve WordPress Posts The workflow fetches all published posts using the WordPress API. It extracts: Post ID Title Link Rendered Content Format Data The retrieved data is structured to ensure correct CSV formatting. Convert to CSV File The formatted data is transformed into a downloadable CSV file. Upload to Google Drive The CSV file is automatically uploaded to a specified Google Drive folder for easy access and storage. How to Use Connect your WordPress and Google Drive accounts to n8n. Run the workflow manually or set up a scheduled trigger. Access the CSV file from your Google Drive folder.
By Codez & AIExport PDF invoices from SmartBill to Google Drive
This workflow automates the retrieval of invoice PDFs from the Smartbill API and saves them to Google Drive in a dynamically created folder based on last month’s date. It also generates a range of invoice numbers, ensuring proper formatting, and uploads each PDF with a structured filename. Overview Trigger and Data Setup: The workflow is manually triggered. It sets the invoice range (start and end numbers), invoice series, the parent Google Drive folder ID and the folder where to save the PDF files. Folder Handling: Folder Name Calculation: Calculates a default folder name based on last month’s date (formatted as YYYY-MM). Invoice Generation: A code node generates invoice items by iterating over a specified range of numbers. Each invoice number is padded to custom number of digits (e.g., 0013), and the invoice series and folder ID are attached to each item. Retrieving Invoice PDFs: For each generated invoice, the Smartbill API is called (using an HTTP Request node) to retrieve the corresponding invoice PDF. How to Use Credentials: Ensure you have configured the Smartbill API (HTTP Basic Auth) and Google API credentials correctly. Parameter Adjustment: Modify the SetData node if you need to change the invoice range, series, or target parent folder. Execution: Click Execute Workflow to run the workflow manually.
By Codez & AI