We are looking for a skilled freelance data analyst with Python experience to extend an existing Google Colab script that pulls SERP data via DataForSEO, by adding functionality for Google Shopping results using the Merchant API.
Objectives: - Use the DataForSEO Merchant API to retrieve Google Shopping product listings for a list of queries from a Google Sheet. - Append the following product data to our output table for each query: -- Product Title -- Product Description -- Product URL -- Position/Rank in Shopping results -- Domain (of product URL) -- Review Count (if available) -- Rating (out of 5, if available)
Existing Setup: - The current Python script: -- Runs in Google Colab -- Pulls a list of keywords from a Google Sheet ("Keywords" tab, column A) -- Uses DataForSEO SERP API for organic results -- You will be expected to build on top of this script
Deliverables: - Updated Colab script with: -- Function to query the Google Shopping Merchant API for each keyword -- Normalised output (DataFrame or CSV) with the above fields
- Error handling and retry logic - Clear documentation in the script - Instructions on how to run and authenticate with DataForSEO
Timeline: - Quick turnaround needed – ideally within 1–2 weeks
You’ll need: - Python (esp. requests, pandas) - Familiarity with Google Colab - Experience working with APIs - Bonus: Experience using DataForSEO APIs
Facebook Business Account Setup Category: Business Writing, Content Writing, Copywriting, Facebook Ads, Facebook Development, Facebook Marketing, Instagram, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $30 - $250 USD
Editor de Video para Redes Sociales Category: After Effects, Content Creation, Social Media Marketing, Video Ads, Video Editing, Video Post Editing, Video Production, Video Services Budget: $30 - $250 AUD
Website AI Character Videos Category: 3D Animation, After Effects, AI Animation, Animation, Blender, Motion Graphics, Video Editing, Video Production, Video Services, Visual Effects Budget: $250 - $750 AUD
07-Jan-2026 22:59 GMT
Cinematic Video Creation Category: After Effects, Audio Editing, Creative Design, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: $250 - $750 USD
Minimalistic Yoga Business Logo Category: Adobe Illustrator, Photoshop, Branding, Creative Design, Graphic Design, Illustration, Logo Design, Visual Design Budget: $30 - $250 AUD
07-Jan-2026 22:58 GMT
3-Second Logo Animation Needed Category: 2D Animation, 3D Animation, Adobe Animate, After Effects, Animation, Motion Graphics, Video Editing, Video Services Budget: $250 - $750 USD
07-Jan-2026 22:56 GMT
E-commerce and Game Scheduler Integration Category: Content Management System (CMS), ECommerce, HTML, Payment Gateway Integration, Payment Processing, PHP, Web Development, Web Design Budget: $250 - $750 CAD
