Load data from excel email attachment to SQL Server

Just came across Make - I’m wondering if it can pull emails, grab the excel attachments, read the data out of excel and write that data to a SQL Server table?

I see the gmail app and attachment iterator, but I’m getting stuck at reading that excel data from the attachment.

Help, gurus!?
tyvm

Save your file in OneDrive as an XLSX file, connect your 365 account, use the Get Range module of the Excel app

Regards,
MSquare

1 Like