This n8n workflow automates the process of replacing images in Google Docs documents using image URLs from a database. The goal is to dynamically update images in templates, generate multiple customized documents, and optionally convert these documents into PDF or Word formats for easy sharing.

The workflow begins with a manual trigger, which can be activated to start the process. It first defines the image URL to be inserted, sourced from a connected database that contains image URLs under a ‘url’ column. Then, it optionally copies a template Google Doc stored in Google Drive, which contains placeholder images for replacement.

Next, the workflow interacts with Google Docs API to retrieve document details, including image Object IDs, necessary for targeted image replacements. It identifies the specific image in the document to replace, which is crucial if multiple images exist. The image URL is then sent via an HTTP POST request to Google Docs API to replace the existing image with the new one, ensuring the document reflects the latest visuals.

After the image replacement, optional steps are available to make the document publicly shareable, and to download the final document as either a DOCX or PDF. These steps enable easy distribution and presentation of the generated documents.

This workflow is particularly useful in scenarios such as updating marketing materials, batch processing personalized reports, or anytime dynamic image updates are required in Google Docs for business or creative projects.