Hi
I’m begin with Make and I’m blocked.
I would like to generate an image with Open AI/Dall E from a Google Sheet where is the prompt to generate image.
When I run the module Open AI to test it, I have an error message "missing value of required parameter ‘prompt’.
It perhaps come from the fact that the cell “Google Sheet - get a cell” is empty. If it’s the case what value do I have to put at this place ?
thanks
You’ll have to create a filter before this module to check if the variable exists and the length of the variable is greater than 0.
samliew – request private consultation
Join the Make unofficial Discord server!
thanks for your answer.
on my Google Sheet, the cell A2 on with Open AI come to take the prompt is not empty so I shouldn’t have the error message in this case. So for me the problem come from an other point.
I’m agree if it’s necessary to do a test to know if there is a value before Open AI work, but in this case, could you please explain me how I have to process because I have no ideas about it.
thanks a lot
Pascal
If you need further assistance, please provide the following:
Please share screenshots of 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:
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
blueprint.json (12.3 KB)
Please provide the input and 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.
Uploading them here will look like this:
module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:
Either add three backticks ``` before and after the code, like this:
```
input/output bundle content goes here
```
Or use the format code 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. Thanks!
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
Please check in input bundle of GPT module that what data is has passed as prompt. Error message means its empty. and as @samliew said. Please add a filter before GPT module.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel
Hi Samliew,
blueprint.json (49.5 KB)
Screen copy download output bundles Google Sheet.pdf (282.9 KB)
Screen copy of Google Sheet.pdf (202.0 KB)
Screen copy of Open AI module.pdf (508.5 KB)
Please find above the screen copy of the different documents.
Hope it will help you to see where is the problem.
thanks a lot for your help
Pascal
I tried this and it worked for me.
Please let us know whether you are testing whole scenarioor running the GPT moudle once only.
While running once only, please pass the prompt in value field manually.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel
Hi,
I have the error message when I test the Open AI module only. It should take the prompt cell A2 in Google Sheet and generate a picture with Dall E. But it doesn’t work.
regards
Pascal
A complementary question.
Somebody sent me a Json file which is a Make scenario as I try do make. I don’t know how I can download it to copy it in my scenarios.
I try with all the option for Json module but don’t see how I can download the file.
If is it possible to copy this scenario in my scenario, could you please explain me how I have to process and which setting I have to do ?
thanks
Pascal
As you suggest I add a filter between the Google Sheet and the GPT module but it didn’t solve the error message.
If you have a JSON file of a make scenario, you need to “import blueprint” in a new scenario development window.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel
Hi
I’m still blocked between my step 1 and 2. It should be little setting problem but I don’t know how solve it, it’s why I ask you help on that.
I want generate a picture with Chat GPT from a prompt which is in a Google Sheet cell A2.
When I run the report for the Google Sheet it’s ok because I have the report. So the problem is on the Chat Gpt module.
Please find below the error message, screen copy of Google Sheet and Open AI module to give you a view on my situation.
thanks in advance for your help
Pascal
screen copy error message.pdf (325.2 KB)
Screen copy Google Sheet.pdf (450.5 KB)
Screen copy Open AI module.pdf (437.1 KB)
