In-Store Products Catalog

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_118":-5,"_20":119,"_22":120,"_121":122,"_123":124,"_25":125,"_24":-5,"_126":-5,"_127":-5,"_128":53,"_129":130,"_131":53,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","cmvp","name","untitled-3746","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","83f9ff1c-5db6-11f1-a0db-1607ee4eb77e","main.ts","fileId","df44c9be-5b82-11f1-8f22-ee650bb23af1","parentId","branchId","df423bf4-5b82-11f1-8f22-ee650bb23af1","branchVersion",2,"latest",true,"createdAt",["D",1780317390467],1,"fileType","script","content","export default async function (req: Request): Promise {\n // 1. Your actual Google Spreadsheet ID\n const SPREADSHEET_ID = \"1HfglQc2Bc1DzsA7ocrMrzB5nRRieffCmdUtZk6daurE\";\n\n // 2. This URL exports your Google Form responses as a clean CSV file\n const csvUrl =\n `https://docs.google.com/spreadsheets/d/${SPREADSHEET_ID}/export?format=csv`;\n\n try {\n // 3. Fetch the data from Google Sheets\n const response = await fetch(csvUrl);\n if (!response.ok) {\n throw new Error(`Google Sheets returned status: ${response.status}`);\n }\n const csvText = await response.text();\n\n // 4. Parse the CSV text into rows and columns\n const rows = csvText.split(\"\\n\").map((row) => {\n return row.split(/,(?=(?:(?:[^\"]*\"){2})*[^\"]*$)/).map((cell) =>\n cell.replace(/^\"|\"$/g, \"\").trim()\n );\n });\n\n if (rows.length === 0 || !rows[0]) {\n throw new Error(\"The spreadsheet appears to be empty.\");\n }\n\n const headers = rows[0];\n const productRows = rows.slice(1);\n\n // 5. Convert rows into a clean array of objects\n const products = productRows.map((row) => {\n let product: any = {};\n headers.forEach((header, index) => {\n const key = header ? header.trim() : `column_${index}`;\n product[key] = row[index] ? row[index].trim() : \"\";\n });\n return product;\n });\n\n // Helper function to convert standard Google Drive links into direct image URLs\n const getDirectImageUrl = (url: string) => {\n if (!url) return \"\";\n // Extracts the file ID from a Google Drive URL\n const match = url.match(/\\/d\\/([a-zA-Z0-9-_]+)/) ||\n url.match(/id=([a-zA-Z0-9-_]+)/);\n if (match && match[1]) {\n return `https://docs.google.com/uc?export=download&id=${match[1]}`;\n }\n return url; // Returns original url if it isn't a google drive link\n };\n\n // 6. START GENERATING THE RSS XML STRING\n let rssString = `\n\n\n In-Store Products Catalog\n https://your-square-site.square.site\n Live look at our current in-store inventory for local pickup.\n ${new Date().toUTCString()}\n`;\n\n // 7. Loop through every product from your French Google Form headers\n for (const item of products) {\n const title = item[\"Nom de l'article\"] || \"No Title\";\n const description = item[\"Catégorie principale\"] || \"\";\n const price = item[\"Prix\"] || \"0.00\";\n\n // Convert the Google Drive link to a direct file stream URL\n const imageUrl = getDirectImageUrl(item[\"Image de l'article\"]);\n\n rssString += `\n \n <![CDATA[${title} - $${price}]]>\n
${description}]]>\n https://your-square-site.square.site/#pickup\n ${new Date().toUTCString()}\n `;\n }\n\n // Close the RSS tags\n rssString += `\n\n`;\n\n // 8. Return the generated XML directly to Square\n return new Response(rssString, {\n headers: {\n \"Content-Type\": \"application/xml; charset=utf-8\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n } catch (error: any) {\n return new Response(\"Error building RSS Feed: \" + error.message, {\n status: 500,\n });\n }\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1780317390467],"children",[],[35],"df417944-5b82-11f1-8f22-ee650bb23af1",["D",1780075307467],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","14aaed17-730d-4ebe-aa08-0d504b485827","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e74c1-94e8-71fd-8555-1fd09f43fdcb","tursoName","df4179445b8211f18f22ee650bb23af1","tursoHostname","df4179445b8211f18f22ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489912439],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_117":-5},"org",{"_11":12,"_111":112,"_113":-5,"_70":-5,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","CMVP","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":151,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":152,"_98":153,"_100":154,"_102":53},[147],"files",[147],"counts",{"_138":77,"_139":47,"_140":77,"_31":141,"_142":143},[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":137},[35],"pulls","branches","forks",{"_144":77,"_146":77},"connections",{"_144":77,"_145":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":148,"_18":149},[],[35],["D",1780075307467],["D",1789489912439],{"_11":12,"_117":-5},{"_11":12,"_111":112,"_113":-5,"_70":-5,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_133":188,"_189":190,"_191":192,"_193":53,"_194":53,"_195":53,"_196":44,"_197":-5,"_198":-7,"_199":-7,"_200":77,"_201":53,"_202":53,"_203":-5,"_204":53,"_205":53,"_206":53,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":16,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code