ChatGPT API Course: How to Automate Everything with AI

Explore the OpenAI api basics, including api keys and tokens, setting up your key on the platform, and using playground and postman for web requests and generating pictures.

Learn how the OpenAI API enables your app to communicate with OpenAI via web requests, using an API key and tokens to manage charges per request and response across models.

Create and secure your OpenAI API key, then explore the playground with ChatGPT 4.0, adjusting temperature and tokens for API calls.

Explore using postman to clone and fork a ChatGPT api collection, sign in, configure an api key, and send requests to test models and chat completion with OpenAI.

Explore APIs, api keys, tokens, and setting up your ChatGPT/OpenAI key, use the playground and postman to make web requests and generate images, and prepare for Google Slides image integration.

Develop an app script to generate an image for Google Slides using Dall-E 2 and 3, and learn to call open API with Postman, plus access image-generation docs.

Follow a flowchart to build a google slides app that validates the api key, prompts for an image, calls OpenAI, downloads and inserts the image, and shows a success message.

Learn to call the OpenAI image creation API with Postman, compare the Dall-E 2 and Dall-E 3 models, and generate images from prompts with options like n, size, and quality.

Create a Google Slides dialog to capture your OpenAI API key, store it in user properties, and expose a menu item to set the key.

Learn how to invoke the OpenAI API from App Script by validating prompts, managing API keys, posting requests, logging results, and generating an image URL with DALL·E 2 or 3.

Fetches the image URL, downloads the image, and inserts it into the current Google Slide, displaying a success message and showcasing OpenAI image generation.

Build a Google Slides app that generates images via ChatGPT using Apps Script to call OpenAI and download images, guided by a clear flow chart.

Explore how to send spreadsheet data to ChatGPT for analysis using a sample car sales dataset, and learn the basics of the text generation API and open API.

Learn how a flowchart guides a Google Sheets app using App Script to validate an API key, convert data to CSV, prompt user, call the API, and show OpenAI analysis.

Learn how to use Postman to call the OpenAI chat completions API, including setting the model, max tokens, and temperature, and understand token basics and pricing.

Learn how to securely store your OpenAI API key in Google Sheets using Apps Script, set up a custom analyze sheet menu, and prep data for analysis with JavaScript.

Analyze google sheets data with OpenAI's API by turning the active sheet into CSV, sending a prompt to ChatGPT, and displaying the assistant's response in a dialog box.

Learn to send data from a Google Spreadsheet to ChatGPT to generate user responses. The next video will cover categorizing data in Google Spreadsheets with ChatGPT and creating ChatGPT functions.

Build and call a custom function to categorize foods with ChatGPT, seeing how categorize_food labels items like fruit or dairy and how to implement the flowchart.

Walk through a flowchart-guided workflow to validate and set the API key, call a custom function with sheet data, and return ChatGPT results in a Google Sheets automation.

Set up the project by copying the food spreadsheet, renaming the app script to food function, adding an api keys menu item, and entering your OpenAI key to enable categorization.

Learn to create custom Google Sheets functions that call OpenAI's API to categorize data, using Apps Script to return a single word category and prototype cost-aware solutions.

Learn to implement a categorize food function in an app script using the chat completion API. Extend to a two-sheet setup with a menu item to categorize food at once.

Learn how to categorize food into clear categories with a live demo that runs about 51 seconds, showing apples, dairy, vegetables, and nuts such as almond butter.

Follow a flowchart to categorize 88 foods by fetching foods and categories, ensuring the api key is present, and inserting each category into the corresponding food.

Set up the project by duplicating the categorized food spreadsheet, implement the categorize all foods function in App Script, and verify the new menu item and API key workflow.

Extract food and category data from Google Sheets with Apps Script, convert the range A2 to last row into a flat list of strings, and prepare it for ChatGPT integration.

Call OpenAI from Google Apps Script to categorize each food in a Google Sheet, returning only the category and updating the sheet after 88 API calls.

Showcases a food categorizer that classifies all foods at once, displays category lists, and teaches how app scripts connect for your own project; next, explore git add generation with spreadsheets.

Learn to control ChatGPT variables with Google Sheets, adjusting temperature, top_p, max chats, and length penalties, and see how to generate and save ad responses with timestamps.

Unravel the ad generation flow by validating API keys, loading prompts from a spreadsheet, looping through prompts, calling the OpenAI API, handling errors, and saving results.

Set up the ad generator project by copying starter code, renaming functions, and configuring the menu and API key, then prepare to start coding and processing data with ChatGPT.

Learn to automate ad generation in Google Sheets by calling ChatGPT and the OpenAI API with multiple models and parameters using Apps Script, and populate a results sheet from prompts.

Celebrate building your own ad generation machine that turns data into ads with ChatGPT. Move on by building a React app with Firebase that uses ChatGPT to analyze videos.

Set up authentication and protected routes with React Router DOM and Firebase to control access to upload, video, and home pages.

learn to set up a react app from scratch using node.js and visual studio code, install libraries like react-router-dom and firebase, and run the dev server.

Open the Firebase console, create a new project named Fire Video Analyzer, enable Google authentication, and set Firestore and Storage to test mode.

Clean up the react app by removing vite boilerplate, deleting app.css and react.svg, and simplifying app.jsx to an h1 within a fragment; update the index title to I Video Analyzer.

Integrate Firebase with React by using dot env and Vite env variables to securely load API keys and config, while avoiding exposing credentials and cleaning up the project.

Add bootstrap to a React app via CDN version 5.3, place the link in index.html, and review the root div, render flow, and built assets before Google login.

Build a navigable React app with React Router DOM by using a template outlet and child routes for home, upload, and videos, plus an error page.

Learn to implement Google login in a React app with Firebase Auth, wiring a Google sign-in button to authenticate via the Google provider and log user data with error handling.

Use the useContext hook to provide a global auth state via an auth provider, and useEffect to listen for Firebase auth changes, updating user and login status for video uploads.

Implement a Bootstrap navbar in React using React Router DOM, showing login state, highlighting the active route, and logging out via Firebase auth to update the auth context across pages.

Move the nav jsx into a new components folder, update imports, commit the change to fix the nav bar, and test by logging in with Google.

Discover protected routes with Firebase authentication and the useContext hook, using an auth context with Firebase active and isLoggedIn to gate pages and redirect unauthenticated users.

Set up login and logout functionality and protected routes, with redirects when logged out. Prepare a solid base for uploading videos and questions for AI analysis in the next section.

Build an upload page to prepare videos and questions for Firebase submission, configure server routes for MP4 videos, and generate AI-assisted quizzes and titles with toast feedback.

Learn to manage the form submit state in a React upload page by toggling a submitting flag, showing a submission message, and wiring setSubmitting to control UI.

Learn how to build a React form with Bootstrap for uploading a single video, manage form state with two-way binding, and handle submission with preventDefault to send data to Firebase.

Learn to manage quiz questions dynamically in a React form by adding, removing, and editing questions with unique IDs generated from unix timestamps.

Upload videos and questions to Firestore, store the video file in Firebase Storage, and record metadata with user ID, creation time, title, questions, and status from created to uploaded.

Configure firestore rules to require a user's uid to match upload data for create, and to enforce read and update only when authenticated, with video uploads capped under one gigabyte.

Replace alerts with toast messages using react-toastify and a global toast container across pages. Learn to display precise errors like storage unauthorized and enforce a one gigabyte limit.

Upload page completed with files in Firebase Storage, secured by rules, and next we will send videos to Speechmatics and ChatGPT to store insights in Firestore.

Learn how to remove a Firebase Admin service key from Google Cloud Console via API Services credentials, including deletion warnings and generating a new key for backend setup.

Set up a back-end project in VS Code, initialize npm to create package.json, install OpenAI and Speechmatics libraries plus dotenv, create video.js and .gitignore, and publish video analyzer back end.

Configure Firebase Admin for Node.js by installing firebase-admin, setting up dotenv, decoding base64 credentials, and wiring the storage bucket URL for end-to-end video transcription with Speechmatics.

Transcribe videos with the Speechmatics API and update Firestore via a listener, using an API key, bucket access, and transcription storage in Firestore.

Set up the Node.js server, Speechmatics transcription, and back-end infrastructure to transcribe video into text. Learn about Firebase Admin, secrets, and the OpenAI library for AI transcription.

Describe a video processing workflow where a firebase listener triggers transcription with Speechmatics, saves the transcription, fetches questions, queries OpenAI for answers, and saves a complete, error-ready document.

Learn to generate and securely handle Firebase Admin service keys for NodeJS by exporting a private key, encoding it in base64, and storing it in a .env file.

Learn to automate video question prompting with Node.js and the OpenAI library by listening for transcribed videos, sending the title and transcript as prompts, and saving generated questions and answers.

Explore how OpenAI and Speechmatics translate and transcribe video, chat with OpenAI through NodeJS, and use Firebase admin with back-end listeners and no endpoints for secure processing.