top of page
Asset 1-8.png
Asset 14-8_edited_edited_edited.png

GPT Reporter

AI driven document generation

Asset 83-8.png
Asset 11-8.png

The GPT Reporter add-on for Google Sheets™ combines Google Sheets™ and Chat GPT AI to generate natural language documents quickly. Select data and text prompts, configure settings, and the tool generates a Google Docs™ file seamlessly.

 

This versatile add-on saves time and helps create professional documents effortlessly. Give it a try today!

Asset 84-8.png
apikey.png

Obtain your API key for Chat GPT

To setup this add on you will need to obtain a API key from OpenAI the creators of Chat GPT. Please follow the below steps:

  • Go to the website of the service that provides the ChatGPT API.

  • OpenAI: https://openai.com/

  • Register for an account on the website if you haven't already done so.

  • Find the section that allows you to generate API keys and click on the "Generate Key" button.

  • Follow the instructions to generate your API key. You may need to provide some additional information or complete a verification process.

  • Once you have your API key, make sure to keep it safe and secure, as it is a sensitive piece of information that provides access to the ChatGPT API. 

  • Select GPT Reporter add on menu and select Set-up API key

  • Enter API Key and press submit​

Set up config for generating document

The next step in GPT reporter is providing the names of the Google Doc template file, key worksheet name, output file name and the temperature setting for use with Chat GPT.  This will inform the add on to obtain the data from worksheet provided and use this data alongside responses received from Chat GPT to generate the output document. The output document will be saved using the filename provided with a timestamp added to the document name. You will be able to find this document in your Google Drive.

Asset 85-8.png
setupscreen.png

Select fields and commands for document generation

Now that the setup is done you can start building the document contents. Please select the Select Document fields menu item and a side bar will appear. This sidebar is a table to which rows can be added or deleted. Each row represent a command such as 
Heading1, Text, Prompt etc. The add-on uses the command alongside the cells in the row to generate the appropriate section in the output document. If you have selected the 'PROMPT' command then the system uses the text in the associated cell range to call Chat GPT and updates he output document with the response returned.

Asset 22-8.png

Generate your Google Document

When the above steps are completed, you will be ready to generate the document. Simple select the Generate AI document option and the system will start processing each row in the table above. This can take a number of minutes for large documents as sometimes the Chat GPT API can be busy. Once the document has finished processing, simply go to your Google drive and fine the new generated document.

Asset 22-8.png

View our Sample Files based on Test 
Spreadsheet with UK spending data.

View our Sample Files based on Test 
Spreedsheet with UK spending data.

bottom of page