Looking for a Make sequence/template someone may already have created, that creates a Google document and emails it. The sequence should populate a template from a data file, save the information into a template as Google Form, then PDF, and email to the recipient email listed in the data file.
What is the problem?
Conceptually straightforward, but when I do it, Make cannot find the Google Form that it successfully created on my Google drive.
I keep getting an error. It says “file not found” but I know it’s there. Here’s the whole sequence I’d like to do:
Read Google sheet in my Google Drive and look for new data. *This works.
Find 1 of 10 different Google doc templates to populate (based on data in #1) and save in Google drive. This works.
For each new row of data, create a new Google doc by saving the template with the ID information found in the Google Sheet (name, email, etc.). *This works.
Find that Google doc and resave it as a PDF. *Error, file not found.
Email that PDF to the email address found in #1 (also located in #2, and #3). *Doesn’t yet work because of error in #4,
We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors.
To allow others to assist you, please provide the following:
1. All Relevant Screenshots
We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.
It would help us identify the issue by having screenshots of:
the full scenario, and the zoomed in parts of the scenario that you are referring to (if your scenario is huge),
a full scenario run/execution from the history (showing output “speech” bubbles),
relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
relevant module input/output bubbles,
if applicable, any error messages,
and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).
Need helpâť“View instructions â—€
We would appreciate it if you could directly upload screenshots here instead of linking to them outside of this forum. This allows us to zoom in on the image when clicked, and also having improved privacy from third-party sources.
Taking Screenshots
Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtScorWinShiftS keys on your keyboard.
MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.
Uploading Attachments
Drag image files directly into the rich-text editor, or
Click on the upload button in the editor toolbar to select files:
2. Scenario Blueprint
Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.
Need helpâť“View instructions â—€
A. Export Blueprint
In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.
You can upload files and images to this forum by clicking on the upload button:
Uploading an attachment here will look like this: blueprint.json (12.3 KB)
B. Create Public Share Link
In the scenario editor, click on the Share button:
Read more about the scenario sharing feature in the Help Centre.
Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.
When you use Create a document in Google Docs, the output already includes a PDF export URL, so you don’t need an extra Get a document or retrieval module.
Just make sure the folder containing the file has sharing set to “Anyone with the link”, otherwise the automation won’t be able to download the PDF.
You can then map that export URL directly in the email body.
If you’re using Gmail, Google Workspace files shared this way may appear as attachments automatically in the email UI.
If that doesn’t happen in your case, you can still use the Download a document module in Google Docs and explicitly download it as a PDF, then attach it to the email.
What is your goal?
What is the problem?
