Hi community! Would love help from anyone who uses @Leandro_Zubrezki’s ConvertKit Pack.
Goal
I am using a Coda form to survey my subscribers and then send that data back to ConvertKit. Here’s the “ingredients” I’m working with:
- The CK Pack’s Subscribers table. Table name =
DB CK Subscribers
- A table to run my survey out of. Table name =
SVRY Segmentation
- Custom fields in ConvertKit. These accept strings of text, nothing else.
- The CK Pack’s
UpdateSubscribers
Action.
The questions I ask in my Coda form are mapped 1-1 with 4 unique custom fields I have for every subscriber on my list.
Flow (v1)
The following steps describe my first attempt at getting this data from subscribers, into Coda, and passed over to ConvertKit:
- Subscriber receives an email from me with a link to my Coda form survey. I pass their unique SubscriberID (managed by CK) as a URL parameter so they don’t have to tell me who they are.
- They fill out the form and submit it.
- The form submission adds a new row to my
SVRY Segmentation
table. Along with their answers, I also recapture their SubscriberID so I can match their form submission to my record of them in my tableDB CK Subscribers
(managed by the CK Pack) via a lookup. - A filtered view of
DB CK Subscribers
shows me Subscribers whose most recent segmentation survey submission does not match what I have inSVRY Segmentation
. This view is calledCK Subscribers who need updating
. - A Button runs the CK Pack’s
UpdateSubscriber()
Action in aForEach
formula that runs over theCK Subscribers who need updating
and populate the subscriber’s most recent survey data in the columns that map to my CK custom fields.
Problem
I run the action, but get this error message:
I’m at a loss about how to proceed. This error message doesn’t provide any advice about how I can resolve this. I’m open to ideas for a different workflow for collecting and moving this data around if anyone thinks that will help. I don’t imagine there’s anything I can do about ConvertKit’s servers so… am I just out of luck?