Zillow/Bridge Interactive and Google Sheets expert wanted

Search more jobs
I have a google spreadsheet with properties and their addresses.

I have a token to use Bridge Interactive and the Zillow API for the purposes of importing Zillow Zestimates and rental estimates.

I'm looking for someone to write a formula(s) which will import the Zestimate value and Zestimate rental value into the spreadsheet.

This is what Bridge Interactive API said to use to Query Zestimate by address

https://api.bridgedataoutput.com/api/v2/zestimates_v2/zestimates?access_token=access_token&address="123 Main Street"

After inputting the url with a test address and my token in the address bar, the results are only text:

"success":true,"status":200,"bundle":["city":"Charleston","lowPercent":12,"postalCode":"29412","BridgeModificationTimestamp":"2022-11-13T01:14:09.437Z","highPercent":11,"houseNumber":"1782","zipPlusFour":"3535","unitNumber":null,"directionSuffix":null,"Latitude":32.739654,"streetName":"Santee","unitPrefix":null,"id":"0eeb19dadbe1d0f9e5d5586cacab8ef4","state":"SC","directionPrefix":null,"timestamp":"2022-11-12T08:00:00.000Z","zillowUrl":"https://www.zillow.com/homes/10894967_zpid/","address":"1782 Santee St Charleston SC 29412","Coordinates":[-79.972511,32.739654],"zpid":"10894967","forecastStandardDeviation":null,"Longitude":-79.972511,"zestimate":417300,"rentalTimestamp":"2022-10-25T07:00:00.000Z","minus30":414633,"rentalLowPercent":0,"houseNumberFraction":null,"streetSuffix":"St","rentalZestimate":2799,"rentalHighPercent":0,"url":"api.bridgedataoutput.com/api/v2/zestimates_v2/zestimates/0eeb19dadbe1d0f9e5d5586cacab8ef4"],"total":1

Hopefully this gives you enough info to suggest a formula. Formulas will be tested prior to payment. Thanks
  • $10.00
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type

Skills and Expertise

Google Sheets Microsoft Excel API Scripting
+ 2 more

Activity on this job

  • 5 to 10
    5 to 10
  • 5 days ago
    Last viewed by client
    5 days ago
  • 1
  • 0
    Invites sent
  • 0
    Unanswered invites

About the client

Member since Jul 10, 2017
  • United States
    Indian Land 4:48 am
  • 52 jobs posted
    64% hire rate, 1 open job
  • $2,648 total spent
    45 hires, 5 active
  • $8.62 /hr avg hourly rate paid
    156 hours
  • Member since Jul 10, 2017

Explore similar jobs on Upwork

Youtube Automation
Fixed-price ‐ Posted 5 minutes ago
Scripting Content Creation SEO Keyword Research Video Editing & Production
Scrapy scripts for the new encrypt project
Hourly ‐ Posted 16 minutes ago
Scrapy Data Scraping

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
Signed contract every week
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo