🔗 Relevant links: - BiggerPockets Rookie Podcast 🎙| How to Find Real Estate Deals 🏡 Faster Using Data 99% of People Ignore - th-cam.com/video/2b1lkE5YHgw/w-d-xo.htmlsi=mV3yHYsiWzAgiaC0 - Tutorial materials 📚 - analyticsariel.teachable.com/courses/
Amazing tutorial! I'm just trying it 😁 A question: I also added some calculated fields but every time Zapier inserts a new raw the formula is not copied, I need to drag manually down to past it
Thanks for walking through the tutorial! You should be able to extend your formulas to say row 1000. That way it will populate for new properties. In my spreadsheet I test to see if property address exists, following a similar formula to this one - www.statology.org/google-sheets-if-not-empty/ That way if there’s no data for the row it doesn’t show an error for the formula
Thank you @@TechInRealEstate . I have already tried that method, but the issue persists: Zapier creates a new row in between. For example, if I have two populated rows in my Google Sheets, Zapier inserts a new row at position 3 instead of filling the existing row 3 with formulas. If you check the subsequent rows, they all contain the formulas correctly. This is an old problem I've never managed to resolve in my Excel automation. 🙄
Thanks for watching! It seems that there is no address or location for the API to read in. If I had to assume in your workflow you are not passing in the address from the email step into the API step. So it does not have an address to search for. Otherwise it could be that the property is an "undisclosed address".
Thanks for watching! If it's for a residential property you can run a report to analyze the deal here - bit.ly/4bEvBiW (if you sign in you get additional free searches)
that site looks cool! Is there something similar that's priced similarly but offers API access to be able to full certain fields into a Google sheets like the video above?
@@DavidChappell41 you can use various web scrapers to retrieve the data into a centralized location like Google Sheets. I co-built Coffee Clozers so that you can skip the implementation work and focus on screening deals and making offers 👍
@@TechInRealEstate sorry one more stupid question. What scraper/tool would allow me to automatically input an address into your tool and pull the results (arv, rent, cocr etc) into a Google sheet? Thank you so much!
🔗 Relevant links:
- BiggerPockets Rookie Podcast 🎙| How to Find Real Estate Deals 🏡 Faster Using Data 99% of People Ignore - th-cam.com/video/2b1lkE5YHgw/w-d-xo.htmlsi=mV3yHYsiWzAgiaC0
- Tutorial materials 📚 - analyticsariel.teachable.com/courses/
Amazing tutorial! I'm just trying it 😁
A question: I also added some calculated fields but every time Zapier inserts a new raw the formula is not copied, I need to drag manually down to past it
Thanks for walking through the tutorial! You should be able to extend your formulas to say row 1000. That way it will populate for new properties.
In my spreadsheet I test to see if property address exists, following a similar formula to this one - www.statology.org/google-sheets-if-not-empty/
That way if there’s no data for the row it doesn’t show an error for the formula
Thank you @@TechInRealEstate . I have already tried that method, but the issue persists: Zapier creates a new row in between. For example, if I have two populated rows in my Google Sheets, Zapier inserts a new row at position 3 instead of filling the existing row 3 with formulas. If you check the subsequent rows, they all contain the formulas correctly. This is an old problem I've never managed to resolve in my Excel automation. 🙄
This is such a game changer
Glad it’s useful!
Hi Ariel, Have you ever ran into the a "Empty location/polygon field" error at Step 4 when integrating the API Webhook?
Thanks for watching! It seems that there is no address or location for the API to read in. If I had to assume in your workflow you are not passing in the address from the email step into the API step. So it does not have an address to search for. Otherwise it could be that the property is an "undisclosed address".
Is there a way to automate data analysis for the properties that wholesalers send to my email?
Thanks for watching! If it's for a residential property you can run a report to analyze the deal here - bit.ly/4bEvBiW (if you sign in you get additional free searches)
@@TechInRealEstate Thanks!
that site looks cool! Is there something similar that's priced similarly but offers API access to be able to full certain fields into a Google sheets like the video above?
@@DavidChappell41 you can use various web scrapers to retrieve the data into a centralized location like Google Sheets. I co-built Coffee Clozers so that you can skip the implementation work and focus on screening deals and making offers 👍
@@TechInRealEstate sorry one more stupid question. What scraper/tool would allow me to automatically input an address into your tool and pull the results (arv, rent, cocr etc) into a Google sheet? Thank you so much!