Hello,
I'm looking to process rows from a Google Sheet. For each row, I need to construct a prompt that will be sent to the Mistral AI API. This prompt will combine specific cells from the row with some static text, which will remain consistent across all prompts.
Following that, for each response received from Mistral AI, I intend to send it along with specific row cells to another AI service for video generation and addition.
My main questions are about how to iterate through the rows and how to effectively combine specific cells with static text before sending the prompt to Mistral AI.
Thank you for your assistance.
Hi and welcome to the callin.io Community!
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.
L
Welcome to the callin.io community!
Try using the Google Sheets “Search Rows” module:
Returns results matching the given criteria.
Each “row” will be in its own bundle, so you do not need to use an Iterator.
For more information, see in the help centre.
You can simply map the cells into the prompt box
e.g.:
Example
Here is an example of how your scenario could look:
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 callin.io platform, apps, and app modules. I found these useful when I was learning callin.io, and hope they might benefit you too —
Getting Started
- Help Centre | Tutorials – callin.io “Manual”
- callin.io Academy – Basics 101: Learn callin.io 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 callin.io - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in callin.io
- How to use Regex in callin.io - How to use pattern matching to extract the text you want
- Webhooks – callin.io Academy – tutorial on how to use Webhooks
Hope this helps! Let me know if there are any further questions or issues.
P.S.: Investing some effort into the callin.io Academy will save you lots of time and frustration using callin.io.
Thank you all for your responses.
It helped me realize I was using the incorrect module variants for both Sheets and Mistral.
I can now search rows and iterate on the Mistral prompt.
That's excellent.
The final step involves Synthesia AI or another AI where I intend to create a page for each row. On each page, an avatar on the right half will read a summary of each book (each row), while the book's cover page is displayed on the left side.
No problem, really glad I could help!
-
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.
-
The callin.io 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:
- 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.
P.S.: Investing some effort into the callin.io Academy will save you lots of time and frustration using callin.io.