What is your goal?
I’m trying to make automated alert via my organization’s sales data
Basically, the functions are:
- uploading CSV with tables of value, YoY change, and share of total sales for each row of products
- use enterprise Gemini to flag products with significant YoY changes or any outlier data
- log those flags into sheets
- use another AI to search for news / ongoing trends with those products as keyword
- return results into another sheet for further investigation
note:
- database that I exported CSV from does not allow direct API call, so I must download and re-upload everything into internal use Gdrive by hand
- naturally CSV file is confidential and thus must not be uploaded directly to public AI
- enterprise Gemini is configured in a way that it only runs on data we feed it, and thus unable to search external data, that’s why I need to rely on another AI
- both flags and search result must always be logged, so that anyone can trace back where that particular info came from
I drafted the scenario like this
What is the problem?
-
I cannot seem to get both Gemini and websearch (placeholder) to write its response into google sheets properly (I’m trying to put in 5 columns in 1st sheet: product, value, change, share, flag; another is source name, URL, summary, details)
-
I don’t know if it is possible to do web search with 2-3 different AIs then aggregate their answers using Gemini again. I wonder if anyone has any recommendation as to how that workflow might look like. Perhaps making different AI do search, put them in google sheets, then link that sheet to Gemini again like this?
What have you tried so far?
For the sheets, I cloned my earlier sentiment analysis scenario (get data from apify → feed to gemini → log everything into google sheets) but it doesn’t seem to work this time.
In that one, I prompted Gemini to read CSV and analyze, then output as JSON like this:
and it went into sheets perfectly fine; the updated row modules see the result and I was able to specify value in columns. However, in this one, when I ordered it to output as
Gemini did give out proper results in the module’s operations. HOWEVER, it gave out Result: 0: xxx, and when I tried to add those value into columns, it does not make any changes to google sheets. I tried other prompts but it either still won’t update or throw entire response into single google sheets cell instead.
I have no idea what is causing this because there is no error message.
Hey, I think the issue is coming from the structure of the Gemini response, not from Google Sheets itself.
Welcome to the Make community!
Please provide the Output bundle of the Google Gemini (module [13]) from the Scenario History, or by re-running the scenario.
Expand Instructions ◀
Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.
A. Upload a Text File
Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.
-
You can upload files and images to this forum by clicking on the upload button:
Uploading an attachment here will look like this:
module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)
B. Insert a Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly with the “Preformatted Text” (code) button in the rich-text editor. Otherwise the forum software will change the content, making them invalid!
Formatting IS Important!
Here are some ways to provide text content in a way that it won’t be modified by the forum.
-
Method 1: Type code fence manually —
Manually type three backticks ``` in a separate line before and after the content, like this,
```
text goes here
```
-
Method 2: Highlight the pasted content, then click the preformatted text/code button —
-
Method 3: Upload your file elsewhere and share the public link —
This method is only advised for large files exceeding the forum upload limit.
Providing the Output bundle will allow others to replicate what is going on, especially if there are complex data structures (like nested arrays and collections) and data from external services. This helps us with answering your question with valid examples, like mapping raw variable names (instead of the label/display name).
This will allow others to better assist you. Thanks!
— @samliew
Hi, thanks for your and Bolex’s response
I’m not sure if this is because I’m using the free plan, but there is no option to download the bundle, instead there’s just the option to view raw output. Can I confirm whether copying that can work as well? (not sure how bundle file is structured vs raw one)
If so, I’ll run some placeholder data through.
Click on View raw output and the button to download it will be on the new popup that appears.
Oh, so structure is the same. Thanks.
I’ve run the placeholder data through and this was the output
module13-output.txt (4.5 KB)
