How To Connect Nano Banana With Google Sheets (get the template for free)

Key Concepts

• Nano Banana: Google's image generation model.
• Gemini API: Google's API for accessing the Gemini model.
• Image BB API: A service for temporarily hosting images.
• Google Sheets Template: A spreadsheet designed to automate image generation using the Gemini API.
• API Keys: Authentication keys required to access the Gemini and Image BB APIs.
• Google Drive Folder ID: A unique identifier for a folder in Google Drive, used for organizing generated images.
• Reference Images: Images used as a basis for generating new images.
• Prompts: Textual instructions given to the image generation model.

1. Introduction to the Nano Banana Google Sheet Image Generator

• The video introduces a Google Sheet template that leverages the Google Gemini API to generate images at scale using the Nano Banana model.
• The template is designed to be more cost-effective than using the Google Gemini app directly.
• It allows users to iterate on prompts and generate hundreds of images at a time.
• The template integrates with Google Drive for easy organization of generated images.

2. Setting Up API Keys

• Gemini API Key:
  • Users need to obtain a Gemini API key from aistudio.google.com.
  • The process involves creating a Google Cloud project (if one doesn't exist) via console.cloud.google.com.
  • Billing must be set up for the Google Cloud project to enable API usage. The speaker mentions spending $2.25 to generate approximately 100 images.
  • The API key is then pasted into the designated field in the Google Sheet.
• Image BB API Key:
  • Users need to create a free account at api.imgbb.com to obtain an Image BB API key.
  • The API key is then pasted into the designated field in the Google Sheet.
  • Image BB is used to temporarily host the generated images because of the way the code is formatted from Google.

3. Understanding the Google Sheet Template

• Manual Prompt (Column A): Allows users to enter a custom prompt that overrides the prompt selected from the prompt library.
• Prompt Library: A table within the Google Sheet that stores pre-defined prompts for reuse.
• Aspect Ratio: While included in the prompt, the speaker notes that Nano Banana doesn't consistently respect the specified aspect ratio.
• Google Drive Folder ID: Specifies the Google Drive folder where generated images will be saved. The folder ID is extracted from the Google Drive URL (folders/[folder ID]).
• Reference Images (Columns with "Reference Image"): Allows users to include up to three reference images, either via URL or Google Drive shareable link.
• Image Previews: Optional formulas that display previews of the reference images.
• Final Prompt: A formula that prioritizes the manual prompt if present, otherwise uses the prompt from the prompt library.
• Output Image: The column where the URL of the generated image is displayed.

4. Generating Images

• The "Generate Images" button triggers a script that processes rows without an existing output image URL.
• The script requires authorization to access Google services.
• The script sends the prompt and reference images to the Gemini API, generates the image, temporarily hosts it on Image BB, and then saves it to the specified Google Drive folder.
• The Google Drive file ID and an image preview are then displayed in the corresponding columns.

5. Use Cases and Examples

• Ad Creation: The speaker demonstrates how to create variations of an ad by using a base prompt and swapping out reference images (e.g., changing the car in an ad).
• AI Influencer Marketing: The speaker mentions the ability to create AI influencers holding physical products.
• Content Creation: The speaker mentions the ability to generate engaging content for social media.
• Example Prompt: "Create an image of a grungy emo vibe influencer in her 20s wearing [shirt] and holding [can]" referencing images of a shirt and a can.
• Example Prompt: Have a man leaning against the new car that's in reference image two and also have him holding a liquid death can.

6. Observations and Potential Improvements

• The speaker notes that the dimensions of the generated images sometimes default to the dimensions of one of the reference images.
• Potential improvements include integrating more image generation models (e.g., Flux, ChatGPT, Midjourney) and using image generator aggregators like Freepick.

7. Conclusion

• The Google Sheet template provides a scalable and cost-effective way to generate images using the Google Gemini API and Nano Banana model.
• The template is highly customizable and integrates seamlessly with Google Drive.
• The speaker encourages users to provide feedback and suggestions for future improvements.