➕Using Macros in Google Sheets

We don't stop at content creation, take your data analysis to new heights with our advanced features!

To set up our Google Sheets Data Processing, Open the Thoughtful Widget and hit Setup Spreadsheet. If you already have Data in the sheet, it will be moved over a few columns starting at column E.

Use Column A for Context (You can add stuff in here manually or grab context automatically from the Entire row, Google, or your stored Documents. Check out our other trainings for more information on these context components)

Use Column B for Command Prompts (Set a single Prompt that will act across all of your various contexts, or if you are doing more advanced prompt engineering testing you can add various prompts but any blank cells in this column will default to use the prompt in cell B2).

Be sure to Leave Column C Blank (That’s where the AI will populate it’s response). And last, column D can be used for notes, and feedback about the AI’s response (which will come in handy if you are finetuning your own models.)

Now, you are ready to process. If you are pulling in an “entire row variable”, be sure to count how many columns of context you’ll want to pull into the task. Start your count at Column E and make sure your headers are labeled because that will give the AI the necessary context to help complete the task). In this example, we’ll take data from 3 columns.

Finally indicate how many rows at a time you’d like to process. Since it’s best practice to supervise the output of AI, we’d recommend that you start with no more than 20 rows. In this example we will only need to process 5 rows.

ThoughtfulGPT will do our best to process as many rows as possible, but for longer prompts and tasks you may have to shrink your batch size.

Use AI Macros to Transform Data in Multiple Cells

Supercharge your Data Analysis with our "Batch Processing" Features

This is one most POWERFUL pieces of functionality we have to offer here at ThoughtfulGPT. It's so versatile and can be set up to tackle almost any project in a snap with a bit of your human creativity.

Check out some of our favorite SpreadSheet Templates!

Copy these into your own account and make them your own

LEAD TOASTER for Cold Sales Outreach

This template uses AI to optimize your outreach strategy by warming up cold emails, increasing your chances of getting a response and generating more leads.

Investor & Customer Scoring

This template uses AI to analyze investors, customers, leads, or anything else for their likelihood to convert. By scoring your prospects based on their behavior and other factors, you can optimize your marketing and sales efforts for maximum ROI.

EMPLOYEE RETENTION DASHBOARD

This AI-powered template helps you analyze employee feedback to predict attrition and improve employee retention rates. With this tool, you’ll be able to identify potential issues before they become major problems and take proactive steps to address them.

GPT PROMPT ENGINEERING & TESTING

With this template, you can plan and test your AI macros and automations using spreadsheets and embedded company search. This makes it easy to optimize your processes and ensure that your AI is working as intended.