I’m trying to create PDFs from a Google Docs template using data from my Google Sheets. Each row in my spreadsheet includes information for the PDF, and one column has URLs of pictures stored in Google Drive.
Although the text appears in the PDF fine, I can’t seem to display the actual images; only the URL shows up. I attempted a tutorial I found online, but it didn’t work as expected.
I even tried inserting the images directly into the spreadsheet cells and then transferring them to the PDF. However, it only displays ‘Cellimage’ instead of the actual picture.
Can anyone provide a solution to properly show the images in the final PDF? Any help would be greatly appreciated!
hey there, i’ve faced this issue before. try using the IMAGE function in sheets. type =IMAGE(A1) if A1 holds the image url. ensure the urls are public so that pdfs show the images correctly. hope it helps!
Having dealt with similar issues, I can suggest an alternative approach that might work for you. Instead of trying to embed images directly from Sheets, consider using Google Apps Script to automate the process. Create a template in Google Docs with image placeholders, then write a script to read data from your Sheet, including image URLs. The script can replace placeholders with actual images using UrlFetchApp to fetch image data, then export the Doc as a PDF. This method requires some coding knowledge, but it’s quite effective. If you’re not comfortable with scripting, there are add-ons available for Google Sheets that can handle image embedding with more user-friendly interfaces. Just ensure your image URLs in Google Drive are set to ‘Anyone with the link can view’ for seamless integration.
I’ve faced a similar challenge before, and I found a workaround that might help you out. Instead of trying to embed the images directly from Google Sheets, I used Google Apps Script to automate the process. Here’s what I did:
- In Google Docs, I created a template with placeholders for the images.
- I wrote a script that reads the data from the Google Sheet, including the image URLs.
- The script then replaces the placeholders in the Google Doc with the actual images using the UrlFetchApp to fetch the image data.
- Finally, it exports the Doc as a PDF.
This method worked well for me, but it does require some coding knowledge. If you’re not comfortable with scripting, you might want to look into add-ons for Google Sheets that can handle image embedding. Some of them offer more user-friendly interfaces for this kind of task.
Remember, when dealing with image URLs, make sure they’re set to ‘Anyone with the link can view’ in Google Drive for this to work smoothly.