Typebot - Scrape Content Demo with Google Sheets

scrape_content_demo.json

{"id":"itlu9p272di2nsy1qsyycxs7","version":"3","createdAt":"2023-03-21T17:58:47.184Z","updatedAt":"2023-03-21T18:25:02.584Z","icon":"🤖","name":"Scrape Content Demo","folderId":"clfhg550l0009m908jsmr2fv4","groups":[{"id":"bsne9ee59gs6bz5e6dvjwfya","title":"Start","blocks":[{"id":"igbipfi63m6p9sl2f77uicuv","type":"start","label":"Start","groupId":"bsne9ee59gs6bz5e6dvjwfya","outgoingEdgeId":"rw99wokhftvhgd0e8aypctgm"}],"graphCoordinates":{"x":-346.7951354980469,"y":187.1693115234375}},{"id":"b0phqof22dzxru1m0a2jhpdn","title":"User input","blocks":[{"id":"ovgk70u0kfxrbtz9dy4e040o","type":"text input","groupId":"b0phqof22dzxru1m0a2jhpdn","options":{"isLong":true,"labels":{"button":"Send","placeholder":"Type your answer..."},"variableId":"vevnx5f5bojz0sv648x6ppcmv","isPrefillDisabled":true},"outgoingEdgeId":"aweji5wfl8jep4p3et9wursv"}],"graphCoordinates":{"x":385.59765625,"y":176}},{"id":"ryonkrzddo27xkscd0k90ebr","title":"ChatGPT reply","blocks":[{"id":"xikptnw1lp1qxdqo10qhmwy1","type":"OpenAI","groupId":"ryonkrzddo27xkscd0k90ebr","options":{"task":"Create chat completion","model":"gpt-3.5-turbo","messages":[{"id":"ny301rrx0y2naje8x8wnmh7r","role":"system","content":"{{system_prompt}}"},{"id":"scla58o6s3kl1cptx0v4qg38","role":"Messages sequence ✨","content":{"userMessagesVariableId":"vevnx5f5bojz0sv648x6ppcmv","assistantMessagesVariableId":"vni6kwbch8zlq92dclgcivzyr"}}],"credentialsId":"clf1d01v20009jv08pl3phyim","responseMapping":[{"id":"n63pht3qy590qyt7vjclmhbi","variableId":"vni6kwbch8zlq92dclgcivzyr","valueToExtract":"Message content"}]}},{"id":"myldn1l1nfdwwm8qvza71rwv","type":"text","content":{"html":"<div>{{Assistant Messages}}</div>","richText":[{"type":"p","children":[{"text":"{{Assistant Messages}}"}]}],"plainText":"{{Assistant Messages}}"},"groupId":"ryonkrzddo27xkscd0k90ebr","outgoingEdgeId":"f56sywj4tz0jidgy61jz755h"}],"graphCoordinates":{"x":744.05078125,"y":178.00390625}},{"id":"o06yqzpn9eaeqkvmq3z1l76p","title":"Intro","blocks":[{"id":"ubbe2s0lk26h2j23bdh50rgv","type":"Google Sheets","groupId":"o06yqzpn9eaeqkvmq3z1l76p","options":{"action":"Get data from sheet","filter":{"comparisons":[{"id":"ofds67a2168qn5iom91me6pi","value":"{{property_url}}","column":"Url","comparisonOperator":"Equal to"}],"logicalOperator":"AND"},"sheetId":"0","credentialsId":"cl366p3qv130009mpvysxvfa6","spreadsheetId":"1rq46tpBpTifaAdw0wHvXbKwouaj5BiAsONISDtlpiao","cellsToExtract":[{"id":"mfntvqsibuyood2pbo8xhauv","column":"System Prompt","variableId":"vtuoi4s94ote5vxv9t502thcq"},{"id":"b98aore4xdyaqo4wjx261nzy","column":"Property Name","variableId":"veqls9e3vbippdw5c0vx5jsj0"}]}},{"id":"gphm5wy1md9cunwkdtbzg6nq","type":"text","content":{"html":"<div>Ask a question about property {{property_name}}.</div>","richText":[{"type":"p","children":[{"text":"Ask a question about property {{property_name}}."}]}],"plainText":"Ask a question about property {{property_name}}."},"groupId":"o06yqzpn9eaeqkvmq3z1l76p","outgoingEdgeId":"q2szx30ehwkpe706fia7ex2d"}],"graphCoordinates":{"x":19.106201171875,"y":172.64080810546875}}],"variables":[{"id":"vni6kwbch8zlq92dclgcivzyr","name":"Assistant Messages"},{"id":"vevnx5f5bojz0sv648x6ppcmv","name":"User Messages"},{"id":"vlqmwxxkt993x5drs1d9ct5bs","name":"property_url"},{"id":"vtuoi4s94ote5vxv9t502thcq","name":"system_prompt"},{"id":"veqls9e3vbippdw5c0vx5jsj0","name":"property_name"}],"edges":[{"id":"q2szx30ehwkpe706fia7ex2d","to":{"groupId":"b0phqof22dzxru1m0a2jhpdn"},"from":{"blockId":"gphm5wy1md9cunwkdtbzg6nq","groupId":"o06yqzpn9eaeqkvmq3z1l76p"}},{"id":"aweji5wfl8jep4p3et9wursv","to":{"groupId":"ryonkrzddo27xkscd0k90ebr"},"from":{"blockId":"ovgk70u0kfxrbtz9dy4e040o","groupId":"b0phqof22dzxru1m0a2jhpdn"}},{"id":"f56sywj4tz0jidgy61jz755h","to":{"groupId":"b0phqof22dzxru1m0a2jhpdn"},"from":{"blockId":"myldn1l1nfdwwm8qvza71rwv","groupId":"ryonkrzddo27xkscd0k90ebr"}},{"id":"rw99wokhftvhgd0e8aypctgm","to":{"groupId":"o06yqzpn9eaeqkvmq3z1l76p"},"from":{"blockId":"igbipfi63m6p9sl2f77uicuv","groupId":"bsne9ee59gs6bz5e6dvjwfya"}}],"theme":{"chat":{"inputs":{"color":"#303235","backgroundColor":"#FFFFFF","placeholderColor":"#9095A0"},"buttons":{"color":"#FFFFFF","backgroundColor":"#0042DA"},"hostAvatar":{"url":"https://lh3.googleusercontent.com/a-/AOh14GgpQRAIjvQpPbbRvSDkXHHpcSIzS8_4oIgOduAz2w=s96-c","isEnabled":true},"hostBubbles":{"color":"#303235","backgroundColor":"#F7F8FF"},"guestBubbles":{"color":"#FFFFFF","backgroundColor":"#FF8E21"}},"general":{"font":"Open Sans","background":{"type":"Color","content":"#ffffff"}}},"settings":{"general":{"isBrandingEnabled":true,"isInputPrefillEnabled":true,"isHideQueryParamsEnabled":true,"isNewResultOnRefreshEnabled":true},"metadata":{"description":"Build beautiful conversational forms and embed them directly in your applications without a line of code. Triple your response rate and collect answers that has more value compared to a traditional form."},"typingEmulation":{"speed":300,"enabled":true,"maxDelay":1.5}},"publicId":"basic-chat-gpt-copy-syycxs7","customDomain":null,"workspaceId":"cl364qm9i330628gcp0iqukihk","resultsTablePreferences":null,"isArchived":false,"isClosed":false}