Skip to main content

Posts

Showing posts from October, 2024

Skip the grunt work: Use AI to turn raw data into Slides (Part 2)

In Part 1 of this series, I showed you how to merge multiple CSV files into a single Google Spreadsheet, with each CSV file stored as a separate sheet. Now, let’s leverage ChatGPT to turn these sheets into a visually engaging Google Slides presentation. The goal of this post is to: Use ChatGPT to generate the Apps Script code for creating a line chart for each sheet in the Google Spreadsheet. Use ChatGPT again to create the code for inserting these charts into a Google Slides presentation. Format and position the charts within the slides to ensure a polished look. We’ll tackle this in three steps: Step 1: Get ChatGPT to Generate the Code to Read and Create the Charts When you have multiple sheets in a Google Spreadsheet and want to create a chart from specific columns, it can be tedious to set up each chart manually. We can use ChatGPT to automate this process. Prompt to ChatGPT "Write an Apps Script function that reads all sheets in a Google Spreadsheet. For each sheet, create a