Here’s a simple scenario:
Lists of companies (in Google Sheets - listed in sheet2) → (get each company name) → Perplexity (get info about the company) – > JSON → Google Sheets (add row with all variables, in sheet1 of the same Google Sheets file).
Even though the JSON is complete, not all variables are transferred to Google Sheets (?!). (sometimes it does - and everything is filled in- , sometimes it does not - and fills some fields only-). I have checked and the JSON is complete, all variables OK, the content is fine.
I’m adding one example of a JSON file with info in all variables, and the GSheets step showing that only one cell has been updated (should be 7). (the only thing different I’m doing is filling column 7 with the array (to string) of the citations used by Perplexity).
I don’t know what to search for, as the scenario works well sometimes.
Any idea, suggestion? Thanks!
Steps taken so far
Checked that the info is correct up to the JSON file.
I even added some ‘sleep’ in between modules (1 sec).
(I also replicated the scenario using Airtable instead of Google sheet. Same inconsistency is happening.. (!) ).
Here’s a simple scenario:
Lists of companies (in Google Sheets - listed in sheet2) → (get each company name) → Perplexity (get info about the company) – > JSON → Google Sheets (add row with all variables, in sheet1 of the same Google Sheets file).
Even though the JSON is complete, not all variables are transferred to Google Sheets (?!). (sometimes it does - and everything is filled in- , sometimes it does not - and fills some fields only-). I have checked and the JSON is complete, all variables OK, the content is fine.
I’m adding one example of a JSON file with info in all variables, and the GSheets step showing that only one cell has been updated (should be 7). (the only thing different I’m doing is filling column 7 with the array (to string) of the citations used by Perplexity).
I don’t know what to search for, as the scenario works well sometimes.
Any idea, suggestion? Thanks!
Steps taken so far
Checked that the info is correct up to the JSON file.
I even added some ‘sleep’ in between modules (1 sec).
(I also replicated the scenario using Airtable instead of Google sheet. Same inconsistency is happening.. (!) ).
A trivial newby error:
Although the JSON was ‘complete and correct’ I then realized that Perplexity was returning the data with slightly different variable names, depending on the run.
I just instructed Perplexity to pass the data with a set of given ‘labels’ for the different information. (for instance, in the past it was returning a company url under the ‘website’ label and other cases it was associated with ‘web’, things like this). The GSheets was expecting to find the data under a given name which not always was the case.
