With SeekWell's Intercom integration you can easily sync data from your database to Intercom. To get started, authorize your Intercom account with SeekWell and then create a new SQL block in SeekWell using the plus sign in the top right of the app:
1. Write your SQL
Write a SQL statement and run the query to verify the results are as expected.
2. Select your destination
Under "Destination" in the right sidebar, select "Intercom".
3. Map SQL columns to the Intercom fields using Mapping UI
After selecting "Intercom" as the destination, click the Mapping option on the bottom of the page next to "Results".
Here you can choose the fields from your query to map to fields in Intercom. You can add additional columns by clicking the green Add Column button. Source columns must be in the result of your SQL query.
Once you map the columns to their respective Intercom fields, you can test the sync by clicking the Test Sync button.
4. Verify the sync
Once you test the sync, you can verify the sync to Intercom was successful by clicking on the metadata above the Mapping UI - this takes you to a realtime Feed of your runs.
In the Feed, you can see all the past runs of a particular block, as well as any errors that may have occurred when sending the data to Intercom. If you don't see your most recent runs, click the refresh button on the top right of the Feed.
4. Set a schedule
Under the "Repeat" section on the right, select the interval (e.g. daily) and time at which you'd like your data to sync.