Creating a Google Sheet image of Gemini Nano Banana

[tarik]

Your Workflow URL

https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjcwNTZkMDYzMzA0Mzc1MjZmNTUzNzUxMzUi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

I've successfully established a connection between Google Sheets and Nano Banana for image creation from a prompt.

I'm also providing it with a product image so it can work with the product I've given it.

But unfortunately, it's not recognizing this image.

I don't know where the error is coming from.

I need help.

Thanks

 

[ArshilAhmad]

Hi @tarik,

Instead of mapping the shareable link, please capture a downloadable link in your Google Sheets trigger step and map that downloadable link to Google AI Studio. We manually entered the downloadable link in Google AI Studio, and it successfully generated an image.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[tarik]

Could you make a video for me because I didn't understand?

The goal was to automate the creation of product images from a prompt and a photo that I upload to Google Sheets.

 

[ArshilAhmad]

The link you captured in your trigger step is a Google Drive shareable link. When you open this link in a browser tab, it only displays the image and does not automatically download it.

Shareable link:
https://drive.google.com/file/d/1hUkO1ABgFS0J12JstkPrCMpU8ECKr08k/view?usp=drive_link


This is a downloadable Google Drive link. When you open this link in a browser tab, the file is downloaded automatically.

Downloadable link:
https://drive.google.com/uc?id=1hUkO1ABgFS0J12JstkPrCMpU8ECKr08k&export=download

Google AI Studio accepts downloadable links, not shareable links.

In any case, we have added a File Uploader (Pabbly) action step to your workflow to resolve this issue. You don’t need to make any further changes to the workflow.


Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[tarik]

I just did a test by adding a downloadable link to the google sheet table, but unfortunately the photo that is created has no relation to the one I add.

 

[Preeti Paryani]

Hi @tarik,

In this case, you’ll need to refine the prompt you’ve provided to Gemini. Please make it more specific, structured, and strict with clear instructions so that the expected output is generated consistently.

Let us know if you need help optimizing the prompt.

 

[tarik]

Look, I'm going to do the test by going through the Gemini site and another one by filling in the table with the same information.

Here is the image I get from the following prompt in Gemini (Picture 1 Gemini_Generated_Image_).
Using the same prompt in the Google Sheet, I get (Picture 2 Google Sheet).

Knowing that I provided the same image for both prompts (Picture 3).

 

[Preeti Paryani]

Hi @tarik,

I couldn't find any images attached.

 

[tarik]

check images attached

 

[tarik]

 

[Preeti Paryani]

Hi @tarik,

Could you please share better images along the prompt used? Or kindly schedule a google meet with us so we can review the issue in real time.

Please schedule one using this link - https://calendly.com/d/cydj-76b-n54/support-from-pabbly-preeti

 

[tarik]

Picture 1 Gemini_Generated_Image_

picture 2 google sheet

picture 3

 

[ArshilAhmad]

We used this image and prompt directly in Gemini, as well as through the Gemini API in Pabbly and got similar results.

Prompt: Photographie produit e-commerce ultra nette du packaging de coloration capillaire végétale, exactement identique à l’image fournie, posé bien droit au centre, fond blanc pur (#FFFFFF), éclairage doux et uniforme, ombre très légère sous le produit, style premium naturel, aucun texte ajouté, aucun accessoire, format carré 1000x1000, qualité studio, prêt pour Shopify

Image Used:

Coloration_Capillaire_Vegetale_Golden_Brown_100_Naturelle_Ayurvedique.png

drive.google.com

Gemini:

Gemini API (Pabbly Connect)

https://pc-integration-receiveactionfiledata.dece388354cb6f838a312b78bdcf709b.r2.cloudflarestorage.com/IjU3NjIwNTY5MDYzMTA0M2Q1MjY0NTUzMiI3Dpc/IjU3NmMwNTZlMDYzNTA0M2Q1MjZkNTUzNzUxMzAipc/1766508962946-kvcilg2jvul.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=f764a8976ca1523e3cdedbfac642b432%2F20251223%2Fauto%2Fs3%2Faws4_request&X-Amz-Date=20251223T165603Z&X-Amz-Expires=86400&X-Amz-Signature=04286ec76a623d9fd64bcf76f209a5eb0d8de81494f6a8342d056f72f2cdb18e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject

Please note that Google Gemini, being a large language model, can generate similar images, but it will not produce the exact same image for both prompts.

We have added a Delay action step to your workflow. Please try adding a new image to your Google Sheets and check how the image is generated.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support