Sticky Note Automation: PostgreSQL & Dropcontact Integration

This workflow is designed for:

• Data Analysts who need to aggregate and process large datasets efficiently.
• Sales Teams looking to enrich their contact lists with validated emails and phone numbers.
• Marketing Professionals who want to automate the collection and enhancement of lead data.
• Database Administrators who manage PostgreSQL databases and require automated data updates.
• Developers interested in integrating APIs for data enrichment and automation in their applications.

This workflow addresses the challenge of manually enriching contact data by automating the process of querying a PostgreSQL database, sending bulk requests to the Dropcontact API, and updating the database with the enriched data. It significantly reduces the time spent on data validation and ensures that the contact information is accurate and up-to-date.

1. Schedule Trigger: The workflow is triggered on a specified schedule, allowing for regular updates without manual intervention.
2. Profiles Query: Executes a SQL query to retrieve profiles from the PostgreSQL database, filtering for specific criteria (e.g., title, domain exclusions).
3. Loop Over Items: The retrieved profiles are split into batches of 250 to manage API request limits effectively.
4. Data Transformation: Transforms the data structure into a format suitable for the Dropcontact API, preparing it for bulk requests.
5. Bulk Dropcontact Requests: Sends the transformed data to the Dropcontact API for email and phone number enrichment.
6. Wait: Introduces a delay to ensure compliance with API rate limits before the next request.
7. Bulk Dropcontact Download: Retrieves enriched data from the Dropcontact API using the request ID.
8. Split Out: Splits the enriched data for further processing or updates.
9. Postgres Update: Updates the PostgreSQL database with the new contact information, marking records as enriched.
10. Slack Notification: Sends a notification to a Slack channel in case of any issues during the process, ensuring timely communication.