This is public project and can be used as inspiration for others or other can submit pull requests with their ideas.

• Create Apps Script Project
• Enable Google Drive API: Enable the Google Drive API from the Services tab.

• AWS API Gateway: Set up an AWS API Gateway that triggers a Lambda function to get AWS Inspector results.

• URL Fetch Service: Use the URL Fetch Service in Google Apps Script to make request to AWS API Gateway.
• Handle Response: Process the JSON response from AWS and prep for CSV conversion.

• CSV Conversion: Convert the processed data into CSV format using Google Apps Script methods.
• Create/Update File: Check if a CSV file exists. If not, create a new one, else update the existing file.