Generating PDF files collectively

Hi there, I am new to Glide. We have made use of DocsAutomator integration to generate PDF files out of our Trainning Portal. Is there a way to generate Course Conclusion PDF files collectively for all studens instead of individualy one by one ??? Out of an Action in the Courses page, this feature would have to select all students attending that Course , produce Certificate PDF files for each of them including Course and Student tables data dynamicaly and have these Conclusion Certificates stored in a specific folder in Google Drive … Would appreciate any guidance. Regards, Eduardo

Hi Carlos, welcome to Glide and the community forum :waving_hand:

When you create a workflow, have a look at the Manual trigger which allows you to loop over tables.

Workflows > Manual Trigger
Loops in workflows

1 Like

Here’s how it would work based on Nathanael’s suggestion:

The core idea: A Manual Trigger workflow in Glide can be fired from a button press in the app Glide, and Loops inside that workflow will iterate through each matching row in a table, executing actions sequentially until all rows are processed Glide.

How it works end-to-end:

  1. Data Layer — You need three tables: Courses, Students, and an Enrollments junction table linking them. Relation columns in Glide connect these so each course knows its students and each enrollment can look up both student and course details.
  2. Template — Create a Google Docs certificate template in DocsAutomator with placeholders like {{student_name}}, {{course_name}}, {{completion_date}}, etc. Configure the automation to use Glide as the data source and map placeholders to your Glide column values. Docsautomator
  3. Trigger — On the Course Detail screen, add a “Generate All Certificates” button that is only visible when the course status is “Completed.” This button fires a Trigger Workflow action, passing the Course ID.
  4. Workflow Engine — The Manual Trigger workflow receives the Course ID, then runs a Loop over the Enrollments table, filtered to only rows matching that Course ID where Completion Status = Completed and Certificate URL = empty. The loop limit can be set up to 1,000 rows, and it processes each matching row through the action steps inside it. Glide
  5. Per Student — Inside the loop, for each enrollment row: call the DocsAutomator “Generate Document” action with the mapped placeholders, then use a “Set Column Values” step to write the returned PDF URL back into the enrollment row.
  6. Storage — DocsAutomator supports batch processing and generates documents. Docsautomator
  7. Result — Students see their certificates in-app via a Web Embed component, and admins can see which certificates have been generated across the enrollment list.

For the Drive part, Google Drive is not a native integration. If you want it as well, perhaps you have to do a Glide Workflows + Make.com scenario. Let me know if you want that.

1 Like