I would like to iterate on rows of a google sheet then for each row, I want to compose a prompt to b e sent to Mistral AI API using some cells (specific columns). The prompt combines some row cells together with a static text (same static text will be used in all prompts). Then for each Mistral response, I will send it together with specific row cells to another AI to generate and add a video.
I would like to understand how to ietrate first on rows then how to combine specific cells with static text before sending the prompt to MISTRAL AI;
What have you tried so far? You can request specific cell data from a Google sheet using the Watch Rows to Get a Cell functions. If you use them correctly in your Mistral API prompt you should be able to get the result you want.
This is just an example. Your final solution may or may not look like this depending on your requirements.
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 —
Thank a lot to all of you who responded.
It helped me figure that I was using the wrong modules variants both for Sheets and Mistral
Now I am able to search rows and iterate on Mistral prompt.
That’s great.
The last step will be Synthesia AI or another AI where I want create one page per row. On each page, an avatar on right half page reads a summary of each book (each row) while the cover page of the book is displayed on the left of the page.
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!
Hope this helps! Let me know if there are any further questions or issues.
