Need your spreadsheet to do a specialized task, such as detecting and deleting duplicate rows automatically? You can build and publish custom add-ons with the Google Apps Script to take your spreadsheets to the next level. Don’t know code? Browse the Google Sheets add-on store to see what features others have built.
Always nice to see other organisations highlight Google Apps Script.
Source: Google Sheets: Zapier app of the day

Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.