{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/39e09f19774546ae8c174ff74dba5879\" frameborder=\"0\" width=\"1670\" height=\"1252\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1252,"width":1670,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1252,"thumbnail_width":1670,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/39e09f19774546ae8c174ff74dba5879-854b273b33abcfa0.gif","duration":1179.309,"title":"Creating a Pro-Rated Revenue Sheet with Zapier and Google Sheets 📊","description":"In this video, I walk you through a preparation sheet idea using Zapier and Google Sheets, specifically tailored for our hospital integration. We’ll cover how to pro-rate revenue for reservations that span multiple months, using a template that includes a Monthly Summary, Reservations, and a Nightly Ledger. I’ve set up an automated system that pulls reservation data every two hours, and I’ll show you how to create a Zap in Zapier to populate this information. Please make sure to create your Zap and customize it to fit your needs. If you have any questions or need assistance with the app script, feel free to reach out!"}