{"product_id":"n8n-vinyl-record-catalog-automation-gemini-google-sheets","title":"n8n Vinyl Record Catalog Automation: Gemini + Google Sheets","description":"\u003ch3\u003eAutomate your vinyl record catalog: Gemini + Google Sheets + Slack, powered by n8n\u003c\/h3\u003e\n\u003cp\u003eStop typing vinyl details by hand. This n8n workflow turns vinyl record form submissions (photos + grading notes) into an AI-extracted, structured catalog entry—uploads media to GoHighLevel, saves the results to Google Sheets, and notifies you in Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a form submission\u003c\/strong\u003e with record photos (Side A\/Side B and optional cover images), plus media\/sleeve condition and location.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini (image analysis)\u003c\/strong\u003e to extract record metadata from the photos and return a \u003cem\u003estructured JSON payload\u003c\/em\u003e (including marketplace title, genre inference, and a suggested CAD price).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and parses the AI response\u003c\/strong\u003e by cleaning it into a flat, valid JSON object to ensure downstream steps can safely consume the data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a media folder in GoHighLevel\u003c\/strong\u003e, prepares the uploaded images, and uploads each available image.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges uploaded image URLs with Gemini metadata\u003c\/strong\u003e, adding a generated record ID, timestamp, inventory fields (status, location, and conditions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the completed catalog entry to Google Sheets\u003c\/strong\u003e as a new row, then shows a success page with saved values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Slack notification\u003c\/strong\u003e on success.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e if the Gemini step fails, the workflow shows an error page, sends a Slack error alert, and stops.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRapid cataloging for a vinyl store or personal collection using an n8n form and photo uploads.\u003c\/li\u003e\n  \u003cli\u003eConsistent grading + pricing suggestions (CAD) generated from photos to speed up listings.\u003c\/li\u003e\n  \u003cli\u003eOperations teams tracking inventory location and conditions in Google Sheets with Slack alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e n8n Form Trigger, Google Gemini (PaLM) API, GoHighLevel media storage, Google Sheets, Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e AI JSON parsing\/flattening, image upload URL merging, row append to Google Sheets, success\/error branching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e create a Gemini API credential in n8n and ensure the selected Gemini model is available; configure Google Sheets OAuth and set the target spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153953607859,"sku":"N8N-20315","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/j3bUQd20FQznc9m3pWWs-_bb6t8QVp.png?v=1790931989","url":"https:\/\/buyflowscripts.com\/products\/n8n-vinyl-record-catalog-automation-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}