Importing Statements to Google Sheet

Importing Statements to Google Sheet

Hi,

I'd like to import all customer statements on a quarterly basis to a Google Sheet with rows for
1. Contact ID
2. Contact Name
3. Mobile No.
4. PDF Link of the statement

with all the statements of the quarter to be in a folder in the google drive.

Could you let me know how I could do that?

Best,
Sushant