A ChatGPT scenario with a prompt database

How To
1

Guys, I am pushing the boundaries of my experience here… I have to build a database in Google Sheets or Google Drive of my ChatGPT prompts. I then have to have ChatGPT pull the prompts I want to use. The scenario is to automate content creation for X posts and LinkedIn blogs.

Any suggestions how to set this up?

My scenario thus far:

Screenshot 2024-10-24 at 7.47.14 PM
Screenshot 2024-10-24 at 7.47.14 PM1313×610 62.2 KB

2

One of the best ways to automate something is to figure out what steps you would do if you were doing it manually.

What are your steps?

My thoughts:

  1. Create a prompt
  2. Store the prompt in Sheets
  3. Pick the prompt to use
  • What is the criterion
  1. Execute the prompt
  2. Push the ChatGPT result to the appropriate platform

Is that what you’re trying to do? If not, detail the steps then it will be easier to figure out what needs to be automated and how.

L

3

Thanks L,

My steps are as follows:

  1. The scenario will trigger from a prompt to my virtual assistant GPT connected to a Webhook trigger.
  2. Grab a prompt from a database in sheets.
  3. Automatically choose the right prompt.
  4. Execute the prompt.
  5. Push the result to the right platform.

So yes, you understand correctly. What I don’t know is:

  1. What module I need to pull the prompt from Google Sheets.
  2. How to get the automation to identify the right prompt.

What do you think?

4

If your assistant is triggering the webhook, it needs to know what the prompts are. You would need to feed it with that information.

You can use the Google Sheets Search Rows action. You would need to adjust your prompt to understand the content in the Google sheets and find the right prompt.

To determine which prompt to use, you could have a column in your sheet that explains what the prompt does. You can test it out with ChatGPT (using the connection to Google Sheets) to see what your prompt nees to look like in order to determine which prompt to use.

If you feel comfortable, you can share the sheet (or create a test sheet to share) so we can see what you’r eworking with and mabe make better recommendations.

L

5

Thanks! I will keep you updated!

1 Like
6

Here are the prompt sheet and the google module…

Screenshot 2024-10-25 at 4.36.51 PM
Screenshot 2024-10-25 at 4.36.51 PM1445×957 70.3 KB

Screenshot 2024-10-25 at 4.37.41 PM
Screenshot 2024-10-25 at 4.37.41 PM1974×1084 270 KB

7

Well, now you need to put data in the sheet and determine how you’re going to access it:

Will you call your webhook with a parameter that tells it which one to use? If so, how is that decision made? Whatever process makes the decision will need to know what information is in the sheet.

If it’s not the calling process that makes the decision but ChatGPT, then you would need to put enough information in the sheet to help ChatGPT make the decision and send all the information to ChatGPT.

If you aren’t changing the prompts regularly, you can create a PDF document that contains all the information:

  • What a prompt does
  • When it should be done
  • The actual prompt to execute

There is more than one way to do this.
L

1 Like