Documents downloaded from a link list — into a folder and a catalog

The scenario takes links from таблица, downloads the documents, files them in OpenAI and keeps a catalog with file details and an error log.

  • Hundreds of files with no manual downloading
  • Broken links are flagged, not lost
  • Details of every file land in the таблица catalog
  • Runs on a schedule or from another scenario
Google Sheets
Set it up for yourselfScriptera

How it works

To move data from OpenAI to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Manual Trigger
  2. Then: Read Pending PDF URLs
  3. Check: Loop Over PDFs
  4. Then: Completion Summary
  5. Then: Prepare Download Info
  6. Check: Is Valid URL?
  7. If yes: Download PDF
  8. Check: Download Success?
  9. If yes: Upload to Google Drive
  10. Then: Extract File Metadata
  11. Then: Save to PDF Library
  12. Then: Update Source Status
  13. If no: Mark as Failed
  14. Then: Log Error
  15. If no: Mark as Invalid
  16. Starts when: Schedule (Every 12 Hours)
  17. Starts when: Called by Another Workflow

You can launch this OpenAI + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios