I’m trying to create a scenario where I receive a summary of my emails from the week on a Google Sheet once a week.
I want this summary to be prepared by ChatGPT.
Attached is my current scenario.
I am encountering several issues:
The first Google Sheet that receives my emails in bulk creates a new sheet every time I run the scenario, containing only the first email I ever received from my inbox.
→ How can I set up a scenario to run automatically once a week to create a sheet each week with all my emails in bulk from (and only from) that week?
When I reach ChatGPT, I receive an error message: “The operation failed with an error. [429] You have consumed all credits in your OpenAI account, or exceeded your monthly OpenAI budget. To adjust your billing, see the OpenAI.”
→ Do I necessarily have to pay for ChatGPT? Are there alternative solutions to achieve my goal for free?
To run once a week, make sure your scenario is scheduled. Plus, you might need to use the email module instead of the Gmail module. The email module allows you to search for emails which the Gmail module doesn’t let you do. However, I’ve never tried thee email module with gmail so I’m not sure how best to do it. Another option is to have a Google sheet that only accepts emails ans when your scenario triggers, it adds a row to the sheet with the email information in it. Then, another scenario would run once a week and process the sheet.
Yes, you have to obtain an API key to use the GPT models (not ChatGPT itself) with Make—or another app, for that matter. I’m not sure there are free options for API use with LLMs like GPT, but I never looked for them. You can buy as little as $5 of credit to see how long it lasts and determine if the time you save with this process is worth the investment.
I have tried to change my module to from GMAIL to EMAIL ; I face the same issue, when I launch the scenario, only the first email ever received in my inbox is in the Google Sheet.
I would like to set up the scenario to run every week so that the emails from the week are CC’d to this sheet. Or at least to ensure that each time the scenario runs, the last 10 received emails are CC’d into the Google Sheet. How can I do this?
Can you share your Email Watch configuration? Can you also show the input/output bundles for watch email to see? You could also export your blueprint and share it here so others can download, test it on their end and see what the problem could be.
To download the blueprint, click on the three buttons at the bottom of your scenario and click “export blueprint”:
Polling Triggers: Epoch Panel & Selecting Older Data
Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.
You can also select other old data to re-run your scenario with next using the “Choose manually” option. This will then show you a list of previous historical items you can select to process the next time the scenario is triggered.
You need to use a Text Aggregator to combine ALL the bundles from the Gmail module.
Aggregators
Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
4. Issue Four
ChatGPT doesn’t work on Make
“ChatGPT” (including Plus) and “OpenAI GPT models” are two separate products. Did you confuse these two?
The consumer chat “ChatGPT” at chatgpt.com is NOT compatible with Make.
Make uses the “OpenAI GPT models”, only accessible via the OpenAI developer platform.
OpenAI APIs for developer (commercial) use does not have any free plan
To resolve this issue,
You can buy credits on the OpenAI Developer Dashboard, under Accounts
This is the first time Renan_GIRAUD has posted — let’s welcome them to our community!
I would suggest completing the Make Academy before jumping into building a complete scenario.
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 —
You would benefit from free 1-to-1 coaching over screenshare to learn more about Make and fix your multiple problems.
Did you know, this forum has a Hire a Pro category, where you can post your request for off-site specialised help on other platforms (video call/screenshare/private messaging/etc.)? This may help you get your issue resolved faster especially if it is urgent. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services (even offer FREE assistance to help) in other categories like here. Once you have posted in the Hire a Pro category, that will allow other members like me to provide booking links to our calendars for a free consultation and video assistance (including screenshare)!
If you need further assistance, please provide the following:
1. Relevant Screenshots
Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
2. Scenario Blueprint
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
B. Insert as Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
``` content goes here
```
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here.
Did you know, this forum has a Hire a Pro category, where you can post your request for off-site specialised help on other platforms (video call/screenshare/private messaging/etc.)? This may help you get your issue resolved faster especially if it is urgent. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services (even offer FREE assistance to help) in other categories like here. Once you have posted in the Hire a Pro category, that will allow other members like me to provide booking links to our calendars for a free consultation and video assistance (including screenshare)!
Hope this helps! If you have any further questions, please repost in the Hire a Pro category if you find it easier to book a free expert consultation to explain your problem over screenshare.
Thank you for your very detailed response, I’ve made a lot of progress thanks to that!
Can you tell me how to adjust the Groq module to make it works?
I’ve entered the API key,
and I have several parameters to fill in that I don’t understand:
→ Model: Which model should I select?
→ Message → Item 1 → Role: system, user, or assistant?
-----------------------> Content: What should I put?
Do i need to add a last module to achieve my goal or it should work ?
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
