Bots and automations | N8N & ChatGPT | ACCOUNTANT BOT | 2023

Learn the essentials of versioning for n8n and node packages, including major/minor versions, compatibility with node 14.15 and above, and how to handle mismatches and potential errors.

Learn to control node versions with nvm by installing and using specific versions. Use commands like nvm list, nvm install, and nvm use, then verify with node -v.

Learn version management for desktop applications and node environments, view the current desktop version, check node versions with node -v, and use nvm to install and switch versions.

Create an account by onboarding the desktop app, complete the initial setup data, and secure access with auto-generated credentials while understanding desktop versus terminal workflows.

Explore how to navigate n8n workflows, templates, and credentials. Connect to external nodes like YouTube, OpenAI, and ChatGPT, and review executions, settings, and multi-user deployment.

learn to navigate the canvas with keyboard and mouse shortcuts, manage nodes and connections, and perform actions like copy, paste, delete, zoom, center, undo, and save.

Design and run a simple two-node workflow that triggers on Gmail receipt and uploads attachments to Google Drive, illustrating how trigger nodes start automation and how credentials must be configured.

Create google cloud credentials by signing in with a gmail account, navigate to cloud.google.com, open the console, and create a new project under APIs and services.

Create a Google Cloud organization and project, activate the free trial with $300 credit, and set up a billing and payments profile for a small company.

Set up Google OAuth credentials for Gmail and Google Drive in a Google Cloud project, configuring OAuth consent, redirect URIs, and enabling Gmail and Drive APIs for integration.

Learn how to troubleshoot Gmail API credentials in an n8n and ChatGPT workflow, including testing, production deployment, and resolving 500 errors.

Create a Google Drive credential with OAuth, a client ID, and a client secret to access Gmail and Drive, then resolve sign-in errors to confirm the account connection.

Automate email attachments with a Gmail to Drive file workflow that downloads attachments and uploads them to a specified Google Drive folder, using credentials and binary data handling.

Understand inputs and outputs in a n8n workflow, where squares mark inputs and circles mark outputs, and data can route to one or many nodes in table, json, or binary.

Explore Json objects and the key value pair structure, learning how to write strings, numbers, booleans, nulls, and arrays in Json inside Visual Studio Code.

Learn how to access data in a json object using dot notation for properties and bracket notation for array indices, including the second student and the third student's age.

Learn the basics of n8n nodes and workflows, including the editor and executions, viewing history, debugging failures, exporting and sharing workflows as JSON, and configuring node parameters and settings.

Explore templates in n8n by building a Gmail to Drive workflow with your own credentials, then review all executions and decide when to use templates or create your own.

Build eight Gmail text-to-doc workflows by setting triggers, Google Docs integration, credentials, and testing the end-to-end email-to-doc automation.

Automate sending any new file uploaded to a specific Google Drive folder to a Gmail address, using a drive-to-gmail workflow that downloads the file and emails it as an attachment.

Automate a workflow that reads Gmail messages, downloads PDF attachments, extracts text from the PDFs, and uploads the text to Google Docs.

Build a Gmail to sheets workflow that appends incoming messages as a new row with the sender and subject in Google Sheets, using the Gmail trigger and sheet credentials.

Advance to more complex workflows by connecting multiple nodes and observing how each node executes and returns data; the annex covers JavaScript basics to help beginners learn JavaScript and Json.

Build an automated image editing workflow in n8n that creates portrait titles and intros, using local file and Google Drive triggers to detect new files and start processing.

Explore using if and switch in n8n to handle two data structures, manage two or more options, and create flexible image title naming from file path.

Explore extracting a title from a file path in N8N using a custom JavaScript code node, by splitting the path, isolating the last segment, removing extensions, and replacing underscores.

Learn to load an image from binary and apply text overlay with the edit image node. Adjust font, size, color, position, and max line length, and explore basic error handling.

Save the final image as a binary file to both the local computer and Google Drive, using JSON data and JavaScript expressions to name the file from the image title.

Google Drive trigger workflow in n8n for image editing, selecting efficient path options, extracting title and file name, and handling binary downloads.

Test image editing within an automated n8n workflow by uploading titles to Google Drive, observing executions in execution mode, and validating background automation for the accountant bot.

Automate invoice intake by monitoring a Google Drive folder for new invoices and Gmail messages, download and read PDFs, and extract data for an automated accountant workflow with ChatGPT integration.

Integrate ChatGPT into automated workflows by creating OpenAI API keys, configuring credentials with your organization ID, and testing JSON-formatted outputs in n8n.

Enable OpenAI billing, run test prompts, and extract invoice data into a JSON with date, concept, total, subtotal, fiscal code, and taxes.

Parse a string into a structured json object for an invoice, extracting subtotal, taxes, and total, converting to a JavaScript object with json.parse, for Google Sheets.

Configure Google Sheets node in an n8n workflow to append invoices by mapping date concept, subtotal, taxes, total, fiscal code, and add an invoice number field as a string.

Test automated workflows process invoices from Google Drive into Google Sheets, debug data handling and fiscal code issues, and compare automation costs with traditional manual data entry.

Automate invoice data extraction with a flexible accountant bot that handles different invoice formats, verifies date and invoice number, and adapts when fiscal codes are missing.

Demonstrate the common issues with PDFs when passing images, and illustrate a scenario using a PDF example.

Test and debug an automated accountant workflow that processes pdf and image invoices via Google Drive, Google Sheets, and Amazon Rekognition, tracks executions, and refines outputs with a cleanup property.

Explore how the automated accountant workflow fixes data by deleting an array, processing pdf and png invoices with read pdf and openai, and validating results in google sheets.

Set up Visual Studio Code with essential git extensions and live server, link a GitHub account, configure git user name and email, and create and publish a first index.js project.

Discover how const and let work in JavaScript, why var is less used, and see that const cannot be reassigned while let can, with practical declaring and logging examples.

Explore how JavaScript functions organize logic, define and call named or anonymous functions, and use arrow functions and callbacks, while mastering order of definition versus execution and semicolon usage.

Explore the basic JavaScript data types: strings, numbers, booleans, null, and objects, and learn about quotes, the difference between strings and numbers, and object properties with keys and values.

Review JavaScript data types, focusing on primitive types—string, number, boolean, null, undefined, and symbol—and non-primitive types like objects and functions, including arrays and date.