Supplier invoices — into a sheet, PDFs — filed by year

The scenario fetches your invoices, records their details in a sheet and files the PDFs into per-year folders in storage.

  • No downloading invoices one by one from the portal
  • Invoice details land as a row in Microsoft SQL, linked to the file
  • The folder for the year is created automatically
  • Re-running doesn't duplicate the records
Set it upScriptera

How it works

To move data from Google Drive to Microsoft SQL automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When clicking ‘Test workflow’
  2. Then: Query Latest OVH Invoices
  3. Then: Convert to Array
  4. Then: Split Out
  5. Check: Loop Over Items
  6. Then: Get Invoice Data
  7. Then: Record in OVH Sheet
  8. Then: Check for FY Folder ID
  9. Check: Does Folder exist
  10. If yes: Create Folder
  11. Then: Download PDF
  12. Then: Safe File
  13. Then: Update Record Data with FileID

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

Similar scenarios