how to generate AI article
input command from Google Sheet
Example: “Write an article to explain What is Social Media”
output in Google Docs
Hello! Welcome to the Make community.
There are many ways to implement it. It depends on the products you want to use (what AI you have a subscription for), the prompt you will do, whether you want to generate one Google Doc for each line in your Google Sheets, or you want to fill one single Google Sheet, etc.
There are a few templates that can help you get started (ex: https://eu1.make.com/templates/10570-create-new-completions-with-openai-chatgpt-from-new-rows-in-google-sheets), but it won’t be enough if you never used Make, since it requires some basic knowledge (bundles, mapping, routers, filters, etc). What is your current knowledge of Make? Did you do the trainings in the academy? (https://academy.make.com/)
Benjamin
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of three modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
- Help Centre | Tutorials – Make “Manual”
- Make Academy – Basics 101: Learn Make and get certified
Help Centre Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
- How to use Regex in Make - How to use pattern matching to extract the text you want
- Webhooks – Make Academy – tutorial on how to use Webhooks
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Because when I run this scenario.
It have error in OpenAI:
RateLimitError
[429] You exceeded your current quota, please check your plan and billing details. For more information on this error, read the docs: https://platform.openai.com/docs/guides/error-codes/api-errors.
Hi @Wee_Chia_Lie and welcome to the Make Community!
This is a common error. To use the ChatGPT you need to purchase credits and provide an API key. If you don’t, you get the message that you exceeded your quota.
If you click on the link, it tells you where to go to buy credits.
If you still have credits, try using https://platform.openai.com to see if you can do something there. If you can, then the problem is something in your scenario. It could be a specific key that has been deactivated. Or a typo. Or a bug, in which case you shoudl reach out to support.
L
L
1 Like