Please find below sample for Google Sheet Script and Formula Automation
Google Sheet Automation. Apps Script
Python CODE - Mail Merge (Google API - DOCs - Sheets, Drive)
Here are some Google Sheet project review
