JotForm to Google Sheets Automation

I need an automation setup to transfer all JotForm submissions to Google Sheets. Additionally, you will need to pull data from a custom API to update the Google Sheets.

Requirements:
- Transfer all JotForm submissions to Google Sheets
- Pull data from custom API to update Google Sheets
- Create a mapped view of addresses (street addresses, city and state, postal codes)
- Color code addresses by specific tags

Ideal Skills and Experience:
- Experience with JotForm and Google Sheets integration
- Proficient in working with custom APIs
- Knowledge of mapping tools and address visualization
- Ability to implement color-coded tags on maps

Please provide examples of similar work.