Google Sheets Automation Setup

I’m looking to work with Google Sheets and feed into Looker Studio. The goal is to replace the current manual steps with Apps Script automations, so the entire pipeline—from data collection in Sheets to live reporting in Looker Studio—runs hands-free... (Budget: ₹600 - ₹1500 INR, Jobs: Automation, Data Integration, Excel, Google Apps Scripts, Google Chrome, Google Data Studio, Google Sheets, Java, Scripting)