How to use the PMax Whisperer Script & Sheet

There are two key things you’ll need to use this Script/Sheet tool.

1. The Google Sheet created using the latest version of my PMax Script (currently v70) and,

2. The PMax Whisperer v70 script installed and setup

If you haven’t yet bought my PMax Script, head to PMaxScript.com

or head straight to the checkout page

Follow the instructions, get it all setup, then come back here. The benefit being you can use AI to get insights on data for YOUR account once your pmax sheet is setup.

Next, install the PMax Whisperer script & copy the template sheet (link in script)

Let’s walk through the various settings you’ll need on your Sheet

Choose the Reports - tick the reports you want to create. Note some of these require the 'advanced' options in the PMax Insights sheet to have run first

PMax Sheet URL - the URL of the sheet you created when you setup the latest version of my PMaxInsights script

Choose LLM - new for v7, choose if you want to use OpenAI or Anthropic

AI Model to use - no need to change this, but if you want to save a few pennies, choose 'cheaper' (better means GPT4o or claude3-opus)

API Key - don’t worry, you’ll struggle to spend a few dollars a month, but you do need this. Get yours OpenAI Anthropic

Language - pick your language from the list (you can type yours over the top of the dropdown if it’s not there!)

Use Voice? - do you want to generate an audio version of your chosen report, tick if you do

Voice - choose the OpenAI voice you’d like to use. Click the link to hear samples of each.

Google Drive Folder ID - this is where your audio files are sent. Instructions here Note you must include a folder ID if you want an audio file created (it needs to get saved somewhere)

Email Output? - do you want results emailed, tick if you do

Email to - enter the email address (just one) of the person you want the output sent to (it might not be possible to send it to yourself)

Next, install the script in your Google Ads account.

Put the URL of your PMax Whisperer sheet between the single quotes at the top (SHEET_URL = ‘’) Name, Authorise (a couple of times) & Save the script Hit ‘Preview’ to run the script & see the logs as they happen - or just hit ‘Run’ Once it’s working the way you want, schedule the script to run as often as you like (probably weekly, there's not much extra value running it daily) Your chosen report(s) will be added at the top of the ‘Output’ tab (& emailed if you chose that option). The Audio version will be saved in the Google Folder you choose & a link shown in the logs & in the email & on the Output tab.

Get Updates, Make Feature Requests & Say Thanks!

If you’d like to get a very occasional email from me letting you know when a major update is made to the scripts, drop me your email. Note, I don’t email every time I update the main script (which is typically every couple of weeks), just major updates. And I would LOVE to hear how this tool could be better. I’ve already got lots of ideas, but I always love to hear more. Please let me know if you’ve got an idea you think would help the majority of users.

And if you’ve read this far - thank you

But what if you don’t have the PMax script? Can you still use the Whisperer?

Yes!! I’ve added a report option, so that even if you don’t have my latest PMax script, you’ll get value from the Whisperer script. Just paste the data you want to analyze into the tab ‘myData’, choose that report option in Settings & run the script in the normal way 🙂 Have a look at the 'example myData' tab if you want to copy/paste data for a quick test

Thank you - you’re awesome!

What is the Whisperer script?

How to find your Google Folder ID