Pulling lists of Emails into Bubble

Hi there,

Has anyone had any luck allowing Users to import their Email lists into Bubble ?

I have got the Google Contacts API working … up to a point… but the data being returned is going to be very hard to parse sensibly.

So have switched to Mailchimp, but the existing plugins seem to be focused on a single Mailchimp account, rather than the User authenticating and using theirs.

Ideally I would pull in lists of emails, and then use Mailchimp to send - although the complication is that each email will have a unique reference, it can’t be bulk so will probably have to use Sendgrid or something.

Anyone done something similar ?

1 Like

In case anyone is interested.

You need to do some jiggery-pokery with the data centre (dc) value that needs to go in the URL for the API calls. It comes back on the login, but I couldn’t get to it that way, so after the login I do a call to the metadata endpoint and store it on the user for use in subsequent calls.

You will probably need to set up a couple of Authorised Apps in Mailchimp for both Dev and Live.

1 Like

Hi @NigelG , I realize you posted this a long time ago, yet still big issue for me. Like you I made the integration work with Google Contacts but not “using it”. I am trying to import the “payload” into my database (under a table called “contacts” basically) but haven’t figured out a way to transform it.

  • Were you able to parse the data returned by Google Contacts API?
  • Would you use the Regex functionality or a Plugin somehow?
  • Any thought/advice!
    Thanks a lot!
1 Like

You should be able to parse it. Even if you use a Regex to turn it into a list.

Haven’t done it with Google Contacts though.