GPT formula

Lido's GPT formula allows you to use OpenAI API from a spreadsheet

Lido's GPT formula allows you to use OpenAI API from a spreadsheet

=GPT(<your OpenAI credential>, prompt, output_cell)

Obtaining an OpenAI API key

  • Create an OpenAI account if you don't have one at openai.com; when prompted, choose API as the desired usecase.
  • On the API Key Page, press "Create new secret key".

Adding OpenAI API key to Lido

  • Type =GPT( in any cell in Lido. A drop down list will appear with your existing OpenAI credentials and the option to add a new OpenAI credential.

  • Press "Add Credential" to add a new credential

Example: using the GPT formula to compose emails

  • Here is an example of GPT formula being used to compose a personalized email to remind their customers to renew their subscription

  • To run the GPT action, right click on the cell containing the action and press "Run Action"

  • The result of the GPT call will be placed in the cell specified by the output_cell argument in the GPT formula. In the above example, output cell is H2