Exploring SerpApi’s Google Product API search types: offers, specs, and reviews
Published in
16 min readJun 18, 2021
SerpApi is able to scrape a Google Product’s HTML page. This case study will showcase the data that potentially can be scraped with the added parameter search types: offers , specs, and reviews .
There is a lot of data found to be found on Google Product pages that SerpApi can scrape. This documentation showcases the type of data we are able to scrape, and more of the specific parameters you can put into play with our queries: https://serpapi.com/google-product-api
Here’s an example of a PS5’s Google Product Page:
product_results, sellers_results, related_product,s specs_results, and reviews_results.There is data for the fields:product_results sellers_results related_products specs_results and reviews_results.These fields on the initial Google Product query may cover the entirety the data. But when using one of the search types of offers, specs, or reviews you will get more precise information.
When we use the these search parameters on this card in the playground. Or in your code implementation with either offers, specs or reviews set to “1”:
We can see how the search changes and focuses specifically a data type.
Below are the different HTML vs. JSON for each one of these search types. You can see how quickly the data changes.
Here’s an excerpt of JSON responses highlighting between the three:
Offers (first 5 results):
{
"online_sellers": [
{
"position": 1,
"name": "Silicon Nerd",
"link": "https://www.google.com/aclk?sa=L&ai=DChcSEwiN7Nqd4J_xAhUTbW8EHZHIByMYABAEGgJqZg&sig=AOD64_0QDhbQfRCGTk4FLV_WS_UNUgKURQ&ctype=5&q=&ved=0ahUKEwiHyded4J_xAhXYWc0KHc7vC04Q2ikIJA&adurl=",
"base_price": "$549.00",
"additional_price": {
"shipping": "$0.00",
"tax": "$0.00"
},
"total_price": "$549.00"
},
{
"position": 2,
"name": "Electronic Gadgets Shop",
"link": "https://www.google.com/aclk?sa=L&ai=DChcSEwiN7Nqd4J_xAhUTbW8EHZHIByMYABAIGgJqZg&sig=AOD64_29UCQYmdj0b4HZO3xd6kv-lwcUwA&ctype=5&q=&ved=0ahUKEwiHyded4J_xAhXYWc0KHc7vC04Q2ikIKA&adurl=",
"base_price": "$550.00",
"additional_price": {
"shipping": "$0.00",
"tax": "$0.00"
},
"total_price": "$550.00"
},
{
"position": 3,
"name": "StockX",
"rating": "78%",
"link": "https://www.google.com/aclk?sa=L&ai=DChcSEwiN7Nqd4J_xAhUTbW8EHZHIByMYABAGGgJqZg&sig=AOD64_1k_C3gO3FWFVI5uF45JzDNWMavVw&ctype=5&q=&ved=0ahUKEwiHyded4J_xAhXYWc0KHc7vC04Q2ikIKw&adurl=",
"base_price": "$1,000.00",
"additional_price": {
"shipping": "$13.95",
"tax": "$110.00"
},
"total_price": "$1,123.95"
},
{
"position": 4,
"name": "Mercari",
"link": "https://www.google.com/aclk?sa=L&ai=DChcSEwiN7Nqd4J_xAhUTbW8EHZHIByMYABAFGgJqZg&sig=AOD64_10YyVYmV7B3AXBtbF72MEMLKEoDg&ctype=5&q=&ved=0ahUKEwiHyded4J_xAhXYWc0KHc7vC04Q2ikILw&adurl=",
"base_price": "$950.00",
"additional_price": {
"shipping": "$0.00",
"tax": "$78.38"
},
"total_price": "$1,028.38"
},
{
"position": 5,
"name": "TecoBuy",
"link": "https://www.google.com/aclk?sa=L&ai=DChcSEwiN7Nqd4J_xAhUTbW8EHZHIByMYABAKGgJqZg&sig=AOD64_2ilgk-zXk3cJUiZfS9oQuh8eUHuw&ctype=5&q=&ved=0ahUKEwiHyded4J_xAhXYWc0KHc7vC04Q2ikIMw&adurl=",
"base_price": "$959.00",
"additional_price": {
"shipping": "$0.00",
"tax": "$0.00"
},
"total_price": "$959.00"
},
]
}Specs:
"specs_results": {
"general": {
"product_type": "Game console",
"internal_memory": "825 GB SSD",
"media": "Ultra HD Blu-ray",
"processor": "1 x AMD Ryzen Zen 2 3.5 GHz - 8-core",
"ram": "16 GB GDDR6 SDRAM at 448 GB/s",
"graphics_processor": "AMD RDNA 2",
"floating_point_performance": "10.3 TFLOPS",
"network": "Gigabit Ethernet, 802.11a/b/g/n/ac, Bluetooth 5.1",
"features": "Tempest 3D AudioTech, Ray Tracing Acceleration, 4K 120fps",
"hd_streaming": "Yes",
"width": "15.4 in",
"depth": "10.2 in",
"height": "4.1 in",
"weight": "9.92 lbs",
"first_seen_on_google_shopping": "November 2020"
},
"controller": {
"type": "DualSense - wireless",
"controls": "PS button, directional buttons, action buttons, touch pad, dual point touch pad, Options button, Right stick, Left stick, L1 Button, L3 Button, R1 Button, R3 Button, R2 Button, L2 Button, Create button, Mute button",
"features": "Motion sensing (6 axes), built-in speaker, headset port, built-in microphone, capacitive touch pad, Click Mechanism, haptic feedback, adaptive triggers"
},
"video_output": {
"tv_connection": "HDMI",
"resolution": "8K (4320p)",
"hdr_capable": "Yes"
},
"interfaces": {
"connector_type": "HDMI output USB 2.0 2 x USB USB LAN"
},
"miscellaneous": {
"power_consumption_operational": "350 Watt",
"included_accessories": "USB cable, HDMI cable"
},
"universal_product_identifiers": {
"brand": "Sony",
"gtin": "00711719541028"
}
}Reviews (first 5 results):
"reviews_results": {
"ratings": [
{
"stars": 1,
"amount": 1281
},
{
"stars": 2,
"amount": 416
},
{
"stars": 3,
"amount": 630
},
{
"stars": 4,
"amount": 2180
},
{
"stars": 5,
"amount": 29384
}
],
"reviews": [
{
"position": 1,
"title": "A Silent Soilder",
"date": "December 5, 2020",
"rating": 5,
"source": "AJ2020 · Review provided by Best Buy",
"content": "I am enjoying my Playstation 5 load times for my PS3 PS4 AND PS5 GAMES. The system is extremely Quiet it makes no noise no matter the work load that I give it. The quality of the Playstation 5 is awesome including the Controller and stand that comes with the Console. The Console has like this brick like texture design on the inside of the white pillars That feels good to the hand. You can also take the Pillars off and Customized your PS5 pillars by Painting them whatever color you want to. You can also add your name and designs on the pillars without causing any damage to the PS5 internally and Externally. So over all the Quality of the system is A 5star rating for me. The Console does not over heat and it plays smoothly the positioning of The PS5 is Customizable because it comes with a stand that allows you to sit it up vertical or Horizontal The Console can also sit up vertical without its stand. The PS5 To me is Vaule at the correct price because you not only get a 4k to 8k gaming experience you also get a Entertainment Center all in one package, At the same time The PS5 is completely backward Compatible with my PS4 DISC AND DIGITAL Games. So the vaule of the system i also give it 5 stars. The PS5 Still has alot of updates that is coming to its operating system/UI that will allow it to have the expandable storage option, and that will allow even more smoother connectivity with PS3 and PS4 games. I have Also given a Over all five star rating to how efficient it is to operate the PS5 system. The boot up time is like 3to 10secs max from the moment you press the power button on the console or controller you go straight to your log in screen and within 2seconds you are looking at your interface which is extremely easy to use. The interface Separates your game media from your entertainment media meaning when you only want to game you just scroll over to the gaming media side, and when you want to watch all your entertainment media like YouTube or Hulu and Netflix you just scroll over to the entertainment media option which is less then a second. Now things get even easier with the Ui of the Playstation interface when you use something called switcher which allows you to jump from game to game or from YouTube back to any game or media App the transition is seemless and so fast. If I had to say anything bad about the PS5 it would be its starting out storage capacity of only 667gb of storage and the fact that the stand comes off to easily when sat Horizontally other then that My Game system is a PYT. "
},
{
"position": 2,
"title": "PlayStation or Xbox Series X",
"date": "December 1, 2020",
"rating": 5,
"source": "Dare2roll · Review provided by Best Buy",
"content": "I am lucky to have acquired both next-Gen gaming consoles the Xbox series X and the PlayStation 5.\n\nPS5\n-Standard Unboxing just like PS4\n-New Dual Sense Controllers feel amazing and is rechargeable\n-Free game installed Astro’s playroom\n-Only Console with Next-Gen exclusives at launch\n-Cool futuristic design at least the digital version looks cool the disc looks like it was just slapped on last minute\n-SSD is really fast\n-Great and easy to use User Interface\n-Games look amazing\n\nPS5 CONS\n-slightly weaker specs\n-Only 825gb of storage??\n-Still some bugs to work out\n\nXBOX SERIES X\n-Unboxing was cool almost Apple like\n-Game Pass (game library)\n-Design fits more to blend in and is really cool and is very Apple like as well.\n-Has better Specs on paper\n-Quick Resume is cool\n-Microsoft has deep pockets just bought Bethesda\n\nXBOX SERIES X CONS\n-No Next-Gen exclusives at launch\n-Same Controllers basically that still need batteries\n-I’m personally sick of another subscription (game pass)\n-Still some bugs to workout\n\nRight now I think PS5 is the better system right now comes with Astro’s Playroom and currently playing Miles Morales and Demon souls is just amazing. But that may change in the future because Microsoft just bought Bethesda (Doom, Fallout, Elder Scrolls) for their GamePass subscription which can be a pro or con depending how you look at it. They want to be like Netflix of games and push another subscription to drain our wallets is the way I look at it. I love Halo and the Fallout series so I’m keeping both systems. I also read another review that said the PS5 was crashing on the new Call of Duty and I can tell you it’s the games fault not the system because my Xbox series X was crashing too playing it as I prefer to play First person shooters on Xbox because of the controller. Although the PlayStation’s new controller will give Xbox’s controller a run for its money because of its interactiveness. Overall both systems are really good and I’m keeping both but I will have to give the edge to PlayStation because it’s overall package just feels next Gen where the Xbox series X just feels like a really really powerful Xbox! PlayStation 5 stars Xbox 4 stars! "
},
{
"position": 3,
"title": "The Next Generation Console We've Been Waiting For",
"date": "December 16, 2020",
"rating": 5,
"source": "Smithic · Review provided by Best Buy",
"content": "The PlayStation 5 takes many steps forward from its predecessor the PlayStation 4. The leap between the PS4 and PS5 is much more substantial than the PS3 to PS4 or even the PS4 to the PS4 Pro.\n\nGames run beautifully on the next-gen hardware and rarely do I ever experience any crashes or performance issues while gaming even after owning the console for over a month.\n\nBy far the best feature of the PS5 is the new DualSense controller, which at first I was not a huge fan of. Initially I hated the design of the controller and I disliked how big and bulkier the controller was compared to the DualShock 4, however after holding the controller in my hands and using it daily sense launch I can say this is the best controller I've ever had the privilege of using in my life.\n\nThe haptics in the controller are great and it's so responsive especially when playing FPS games where the adaptive triggers actually simulate the feeling of pulling the trigger of a gun. The controller feels a lot more premium in the hands and it's very hard to go back to the DualShock 4 after using the DualSense for so long. The controller makes the DualShock 4 feel and play like a cheap knock off. The built-in microphone the controller features is an excellent touch and it's very convenient for gamers who can't afford to by a good headset with a mic. My only gripe with the controller is that when in party or game chats all the voice audio comes through the controller speaker unless you have headphones plugged into the controller. You can always turn off the mic on the controller and essential mute yourself which is another plus.\n\nDespite the console being huge compared to other consoles as well as its processors, I didn't have much trouble finding a place to put my PS5 in my entertainment center. Although for others, this may be difficult due to the size of the console. I recommend putting your PS5 vertically if you don't have much space for your new PlayStation 5 console.\n\nGaming on the PS5 and using the console for basic functions is very smooth. The UI is very snappy and in a lot of ways an upgrade from the PS4's user interface. They've separated your games and media into different tabs so they're much more easier to find and access. Games look and play especially great in 4K at 60 frames per second and many of the games that take advantage of the PS5 or are exclusive to the PS5 are a blast to play.\n\nThe PS5 is also incredibly silent, unless running an intensive game or playing a disk-based game, the PS5 makes hardly any noise. My particular PS5 does suffer from coil whine but it's only noticeable when I'm up close to the console or I'm playing an intensive game such as Call of Duty: Black Ops Cold War or Marvel's Spider-Man: Miles Morales. No longer will you hear the dreaded jet engine fans that are notorious with the PS4 and PS4 Pro.\n\nDespite not being backwards compatible with PS1-PS3 titles, backwards compatibility is great on the PS5 when it comes to PS4 games. Depending on the game, not only does the PS5 boost performance by increasing the framerate but also the resolution as well. Majority of the PS4's library is compatible on the PS5 so you can play all your games as much as you like without having to worry about re-purchasing them or hoping that they'll get ported over or remade to be compatible on PS5.\n\nLoad times are improved drastically even when playing games off of extended storage drives. What would take minutes now just takes a few seconds. Loading and rendering games is the fastest it's been in a long time.\n\nOne of the major downsides to the PS5 however is storage. Despite being advertise as 825 gigabytes of SSD storage, you can't utilize all that storage as some of that 825 gigs is reserved for the system software. Depending on how you use your console you will be left at around 664-667 gigabytes worth of usable storage and with games getting increasingly larger that usable space will fill up very quickly. In the month since launch, I used up most of my storage on the PS5 and currently only have 29 gigs worth of storage left on my PS5. You can use extended storage drives to storage games but only for PS4 games as PS5 games can only be installed on the PS5 itself since those games are specifically designed for the custom SSD. Sony will later update the console to allow you to expand your storage on the PS5 but as of right now (December 2020) currently there are no SSDs that are approved by Sony to work with the PS5.\n\nThe PS5 currently does not support 1440p resolution or quick resume. To switch between games you will have to close out of the game or go to the home screen on the PS5 and select another game to play it.\n\nAll in all the PS5 is worth the price and is a true generation jump. The experience you get from playing these games and using the console makes you forget about the PS4 in a good way. Gaming has come a long way and I can't wait to see what's on the horizon this console generation. "
},
{
"position": 4,
"title": "Amazing when it doesn't crash",
"date": "December 4, 2020",
"rating": 4,
"source": "grolson93 · Review provided by Best Buy",
"content": "Still shocked I was able to pick one up on launch day after that bungled pre-order shamble back in September and all the scalpers who are ruining the holidays for a lot of parents and kids alike. Anyway, the set-up was pretty messy, there are lots of little tips they don't explain to you, especially when setting up a data transfer from your old Ps4.\nThey recommend using a LAN cable but this causes issues with the transfer, use Wi-fi. Then for some reason, getting the console to not crash every day is a miracle, it happens at least once daily and seems to be tied to using an external HDD. My advice, unless you are actively playing PS4 games off of one, leave it unplugged until you need it; it just causes problems so leave it out until Sony patches this issue. Transferring games from HDD to the SSD, or vice-versa takes forever for some reason, have no idea why. Now, on to the good stuff, the games!\nThey look amazing on next-gen, and the loading times are pretty quick for native ps5 titles. Even in backwards compatibility with ps4 titles that haven't been patched, the load times are noticeably quicker and if the game featured an unlocked frame-rate or dynamic resolution, the ps5 will max these bounds out to deliver a much better experience. Spider-man Miles Morales is probably the best tech demo out there for the system, as it allows you to have native 4k with ray-traced reflections (for a console, this is pretty impressive to see in action) or choose a performance mode that runs at near 4k with slightly cut down fidelity (you won't notice in action) and 60fps. The 2018 spiderman also gets a remaster that gives it many of the same features and is super fun to play in next gen. A lot of games are taking this route of offering a choice between high frame rate or high fidelity with 4k and it is refreshing to see devs give their customers the choice between the two.\nAll-in all, having owned every iteration of the playstation since the OG, this was the most impressive launch line-up and experience I can remember having. Aside from the technical issues (of which there are plenty) I still find myself extremely impressed on what Sony delivered for $500. The value in that price-tag is pretty undeniable and it is an amazing experience! "
},
{
"position": 5,
"title": "NextGen King Has Arrived!!",
"date": "December 11, 2020",
"rating": 5,
"source": "hotnerd · Review provided by Best Buy",
"content": "Going over hardware and software. Not going over the every exact technical specs as you can easily look that up. Software can change overtime, this is review of software at launch. If any hardware hiccups or failures in near future I'll update this review\n\n--Hardware:\n\nPhysical:\nLooks futuristic yet tacky. In my personal opinion, looks doesn't really matter as long it can play next gen games well\n\nLarge console. Standing up it's the tallest home video console.\n\nA lot of air-vents throughout making it aerodynamic, cool, quiet, and does not overheat or get hot with consecutive gameplay hours. This may change in the future if games require more performance out of the system, with similar fate like the PS4 where it was whisper quiet in beginning and became louder over the years with more graphical intensive games.\n\nHas LED lights giving it a PC look (?)\n\nFace plate easy to take out for future customization options (?).\n\n667of 820gb of free download space in console\n\nSwapping SDD is not as easy as Xbox Series X (with it's plug and play method) as you have to remove some screws. Upside is that it's standard and not a propriety SDD.\n\nPS5 is compatible with most PS4 games. If you have an external SDD from PS4 it's just plug and transfer to PS5 internal storage\n\nComes with stand. Console is not entirely flat, so stand is required for horizontal position. You have console in vertical position without stand, but does not have grip (rubber feet) so may slide if bumped into or during an earthquake\n\nFront of console: USB-C, USB-A, power, and eject button\n\nBack of console: Two USB-A (Super Speed), LAN port, HDMI, and power port\n\nWished it had more USB-C ports to be future proof, but guess they kept USB-A for some current accessories to be backwards compatible. Disappointed the PS5 official 3D pulse headset and camera uses USB-A. Also no optical audio port means i can't use some of my surround sound headsets.\n\nLoad times for PS5 games are instantaneous. Ps4 games will load much faster, even without optimized patch.\n\nPs5 have ray tracing giving games realistic lighting effects\n\n-Controller:\n\nConsole comes with one controller\n\nPhysically larger than past DuelShock controllers. Great for those with adult sized hands\n\nGreat tech demo included with 'Astro's Playroom'.\n\nHaptic feedback. Similar to Nintendo Switch HD rumble, but more apparent. Not sure if developers will implement in future their games. Even with Nintendo first party; only '1-2 Switch' and 'Mario Party' from what I recall used HD rumble at great extent and it dropped off after that.\n\nAdaptive triggers. Will feel resistance/push back on triggers if developers implement it in game.\n\nHope both Haptic feedback and Adaptive triggers say the entire lifespan and transfer to PS6 instead of dropping off like the six axis on PS3 and light bar in PS4\n\nHas built in mic. Sound quality is similar to current smart phone on speaker. Has mute button\n\nSimilar to PS4, it has speaker and touch pad. Touch pad is more sensitive this time around\n\nAbout double battery life of Ps4 controller. Able to get in 10 consecutive hours\n\nWished it came with back paddle buttons. Hopefully they release a DualSense Back Button Attachment like they did the DualShock 4\n\nYou can play PS4 games with DualShock 4 or DualSense . PS5 games only can be played with DualSense\n\n--Software\n\nUI, OS is the similar to PS4 with scrolling apps/games (left, right, up, down)\n\nThere's an activity row where you can track your progress on games\n\nOther rows are News and PSN store\n\nThere are notifications popups, but you can turn on 'Do Not Disturb' mode\n\nSimilar to phone's swipe down tool bar for basic profile (trophy list, avatar, user info,etc), accessibility options, sound, Game Base, internet wifi select, controllers (see connected controllers), etc on home screen for easy access.\n\n'Game Base' section is where you make party with friends and chat with them, view friend requests.\n\nShare button this time around will pull up menu to take snap shot, record video, or save video previously played game session for up to 60mins\n\nThere's an 'Your Accolades' feature where you give props to other players. Reminds me of how to give endorsements (Sportsmanship, Good Teammate, Shot Caller) in Overwatch to encourage positivity in online community. For PS5 has Helpful, Welcoming, and Good Sport\n\nThere are accessibility options/preferences you can setup that transfers to your games\n\nThere's a 'Switcher' option where you can change games on the fly, but unlike the Xbox Series X's 'quick resume' does not leave where you left off, and will boot you back to the home screen of that game\n\nPicture-in-picture mode if you want friends to help show you how to get through levels\n\nPS4 games load faster on PS5 if downloaded to SSD. Graphical upgrade depends on publisher if they implement a 'PS5 upgrade\" patch\n\n-For PS5 trophies.\n\nTrophies that have collectables there is a progress bar showing how much left to collect.\n\nThere are also tutorial videos for some games that implement it.\n\nSome trophies once selected will drop you into the level/section where you can obtain the trophy. Again depends on game developer if they implement it.\n\nPS4 trophies on PS5 act the same\n\nBase price for games are $70 ($10 more than last gen); Excluding Special/Collector's editions, DLC, micro-transactions, loot crates, and surprise mechanics\n\nOverall, aside from some odd design choices very capable next gen system. There are some features especially on the controller that developers have to utilize and may not be present in all games. If anything like the PS3 and PS4, going to have thousands of gameplay hours on this system. "
},
]
}With these three separate parameters we can gather a myriad of data that wouldn’t be found on each other’s JSON result. SerpApi’s Google Product API has a lot to offer even beyond the base level of a search. Happy querying!
You can sign-up for SerpApi here: https://serpapi.com/
You can find the SerpApi user forum here: https://forum.serpapi.com/
You can find the API documentation here: https://serpapi.com/search-api/
