Automated Contact Creation from Google Sheets Using AI

This n8n workflow automates the process of creating contacts in LEDGERS based on data updates in a Google Sheet, leveraging AI for data parsing and normalization. It starts with a Google Sheets trigger that monitors for new or updated rows every minute. When a row is detected, the workflow uses an OpenAI GPT-4 model to convert raw sheet data into a structured format suitable for contact creation, guided by a custom prompt. The AI’s response is parsed into JSON, which is then looped through to prepare individual contact entries.

Next, each parsed contact data is sent to LEDGERS via the dedicated API node to create a contact record. After each attempt, success or failure notifications are dispatched through Gmail, ensuring transparency and tracking. This workflow is ideal for teams maintaining contact info in Google Sheets who want to automate the synchronization process with minimal manual effort, utilizing AI to handle variations and inconsistencies in data entry.