Zapier expert with experience in automation and API integrations

I am looking for a Zapier expert with experience in automation and API integrations to synchronize and consolidate all new leads from various platforms into a single Google Sheets spreadsheet.

The platforms include:
• Google Ads (Lead Form Extensions)
• Yelp
• Angi Leads
• HomeYou
• Networx

The ideal solution would involve either:
1. Direct API integration where available.
2. Zapier workflows to automatically collect and organize leads in real time.

If you have experience in setting up similar automations, please let me know how you can help, along with examples of past work if possible.