MyVR <> Zapier Custom Integration
Zapier allows you to connect one app with thousands of others. It gives you the ability to integrate and automate without knowing any code. MyVR had a beta integration about two years ago that I was very much looking forward to using. I can only assume was abandoned.
If I do something more than a couple of times, I look to automate or create a template. It finally ate at me enough that I decided to build my own integration between the two systems myself. So far, I have the reservation trigger setup.
Here are some of the Zaps I'm using now:
- Updated/New MYVR Res Event > Update/Create Google Sheets Row
- Updated/New Google Sheet Row > Post in #Slack
- Updated/New Google Sheet Row > Create Asana Task
- Updated/New Google Sheet Row > Update/Add Google Contact
- Updated/New Google Sheet Row > Update/Add Podio Item
- Updated/New Google Sheet Row > Create Accounting Entry in Xero
- Updated/New Google Sheet Row > Messaging Workflow via Twilio
Would you use a Zapier <> MyVR integration?
I have read dozens of posts from folks looking to integrate, automate, import and export. Zapier can solve most, if not all of those issues, easily. Zapier can save tons of time, effort and frustration.
If anyone would be interested in pooling resources to finish building this integration much quicker, please reach out!
Contribute to the Project!
I still have all the remaining triggers, actions and lookups to build and this is way outside of my wheelhouse. Any help is appreciated!
@steven-talbott-0 I use Zapier to create my cleaning and to do lists. It’s a powerful tool!
I use Zapier for so many things and I would LOVE to be able to connect it with MyVR! (and I should add, I would be happy to contribute)
That would be AWSOME! My guess is that most people don't realize the power of Zappier. There sooo many things that we could do that are not possible now.
Yes, I would love to contribute.
I'm also interested in knowing how you are using some of these other applications in your business - the ones Zapier is connecting to MyVR? Slack, Asana, Podio, Zero, Twilio...
Thanks for the post, Steven!
You are correct that MyVR has a beta of a Zapier integration. We started it a while back and have never officially launched it out of beta. I'd be happy to add anyone that is interested to the beta, we'd love the feedback. It currently supports a wide number of triggers and actions related to inquiries, messages, reservations, and payments.
If you are interested in the beta, send an email to
email@example.com we'll provide instructions for accessing it. As Steven outlines, it's a great way to connect your MyVR account to thousands of other applications, no technical skills required.
Don't hesitate to reach out if you have any questions about the beta.
Thanks Mike, I've just sent my email request.
@jess-milligan - I'm registered! See you there.
Registered - looking forward to this!
@jess-milligan - I have a last minute conflict that I can't rearrange so I'll miss this. Will it be recorded???
I connected my account to Zapier today and was able to create a Zap to add a new reservation to a Google Sheet. A few things I'm not sure about and would love some insight, if anyone knows.
When I create a new reservation two rows with the same date are created on my Google sheet (GS). I have the First, Last, Check-In and Check-Out fields populating the GS. Can't figure out why that is happening. Unless it's moving both the Reservation and the Quote over.
In Zapier, there is a message "Webhook Subscription Not Found. No Subscription! Please contact support if this persists." I'm not sure if this is a MyVR issue or a Zapier issue. This message wasn't appearing when I first created the Zap. After testing and modifying it appeared and is persisting. Best I can tell it is not affecting the GS update.
Lastly, if anyone is using Zapier to manage a shared Google sheet for housekeeping, I'd love to learn more from you.
@mary-freiberg Hi Mary,
I've been working on the same thing: The reservation trigger to google sheets!
There are some known glitches in my applications. The double row entries are one of them. Hoping that will be resolved soon. The second is regarding some of the financial field contents.
I'm using another Zap that is triggered via email whenever a reservation is booked. (I use the email parser because this pre-dates the Beta trial of the MyVR api interface.) What data would you like to populate into the housekeeping worksheet? If it's available in the custom fields we now have, that may be an immediate solution for you?
Do you guys have any "Line Item" fields dropping to the Google Sheet? That can cause multiple rows to be created because of the nature of line items.
Line items are seen mostly in financial context and equivalent to a receipt from the grocery store.
If I buy an apple, an orange and a banana, costing $0.50, $0.75 and $0.50 and decided to write the information from the receipt to Google sheets, it would drop as three rows:
Name. Item. Qty. Price.
Steven. Bananna. 1. $0.50
Steven. Apple. 1. $0.50
Steven. Orange. 1. $0.75
I didn't see you mention any line item
fields but wanted to mention it. There are many ways around this using Zapier's formatter action. You can find more details here: https://zapier.com/apps/formatter/help
I'm happy to help if you have specific questions. I can't think of any other reasons this would happen, especially because Zapier remembers what data has already been processed. It could be a glitch, like you said but I haven't experienced it (yet!).