Related article:

How-to enable Zapier and create your first Zap

Available Hostfully Fields for Zapier.

As you already enabled Zapier and got the first Zap per above article, let's get a little more advanced on the Zap path.

This articles will cover the below apps where you can update your customer database with:

  • Google Sheets

  • Mailchimp

  • TBD (let us know what else you want to cover)

Note: we also provide some ready-made templates on Hostfully PMP - Zapier's integration page where you can just click and use. (and modify as you wish)


Hostfully <> Zapier <> Google Sheets: Update your customer database

For this use case, whenever there is a new booking coming into Hostfully, and if the guest email is not already recorded in the spreadsheet, a new row will be automatically added with your preferred details.

Pre-requisite:

  1. You should already have a spreadsheet on Google, with headers set-up correctly per this Zapier help article. (Basically, first row and first column are not to be empty, or else, newly added line will be on top, not the bottom)

  2. Zapier is enabled within your Hostfully PMP Integration zone.

From your Zapier, create another Zap.

  • Trigger: New or Updated Booking in Hostfully

  • Action: Find or Create row in Google Sheets


Step 1: Choose App (Google Sheets) & Event (Look up Spreadsheet row)

Step 2: You will be prompted to connect to the Google account (of above spreadsheet in Pre-requisite). Once connected, it should look like this


Step 3: You now can Set up action

The red required fields are not to be left empty. In this use case, when a new booking arrives you want to look up in the Email column first if this guest's details is already recorded. (I pick email for its likely uniqueness) If not, a new row will be added for new guest details.

Here is a help article where you can find more details on all the Available Hostfully Fields for Zapier.

You can freely pick from the provided variables, like in the below example:

The bolded text is variable, and grey text is from the test booking, so you can better imagine what the value may look like.

That's all for the setup, and always make sure you Test & Turn it ON at the end if all is good.

Now you can make a test booking to see if it works. My steps above should result in this


Hostfully <> Zapier <> Mailchimp: Update your customer database

In this use case, for every new reservation coming in to Hostfully, your guest email (and other details) will be added to to your Mailchimp contact list. You can also set it up so they are prompted whether or not to be added.

Pre-requisite:

  • You should have a Mailchimp account in place already

  • Zapier is enabled within your Hostfully PMP Integration zone.

From your Zapier, create another Zap.

  • Trigger: New or Updated Booking in Hostfully

  • Action: Add/Update Subscriber in Mailchimp

Step 1: Choose App (Mailchimp) & Event (Add/Update Subscriber)

Step 2: You will be prompted to connect to the Mailchimp account.

Once connected, it should look like this


Step 3: You now can Set up action

Certain fields can be picked up from variable or manual input ("en"). You can tell variable by the bold & grey text in the same place.

Here is a help article where you can find more details on all the Available Hostfully Fields for Zapier.

Below is a summary of the settings.

Once tested ok, the zap can be turned ON.

That's all for the setup. Now let's get to an actual example based on that setup.

(In my setup example above, it's True for "Double Opt-in" field, so guests / bookers will be prompted if they want to be a subscriber)

I created a test booking (booker's email: duc+19@hostfully.com)

Then, as a guest/booker, I was prompted on the subscription

and confirmed

Then, took off the guest/booker hat, I logged in to the Mailchimp account to see the guest details are there

All automated with the power of Zapier.


Hope it helps, and please let us know if you have further questions, via pop-up chat on the right bottom, or via email to support@hostfully.com.

Did this answer your question?