Costa Rica

Do this: Here's an outline for a ZeroWork automation that can identify items in a hotel room image, shop for them using Perplexity Pro, and save the results to Google Sheets: ## TaskBot Outline 1. Image Input&nbsp;&nbsp;- Use the "File" input type to allow uploading of the hotel room image[1]. 2. Image Analysis&nbsp;&nbsp;- Add a ChatGPT 4 building block to analyze the image and identify items[1].&nbsp;&nbsp;- Prompt: "Identify and list all furniture and decor items visible in this hotel room image." 3. Item Shopping&nbsp;&nbsp;- Add a Perplexity Pro building block to search for each identified item[5].&nbsp;&nbsp;- Prompt: "Search for and provide shopping options for [item name]. Include product name, price, and link in an HTML table format." 4. Data Formatting&nbsp;&nbsp;- Add a JavaScript building block to combine all Perplexity Pro outputs into a single HTML table[3]. 5. Google Sheets Integration&nbsp;&nbsp;- Use ZeroWork's native Google Sheets integration to directly save the data[3].&nbsp;&nbsp;- Create a new sheet or append to an existing one. ## Detailed Steps 1. **Image Input**&nbsp;&nbsp;- Configure the TaskBot to accept an image file as input. 2. **Image Analysis**&nbsp;&nbsp;- Use the ChatGPT 4 building block to analyze the image.&nbsp;&nbsp;- Store the list of identified items in a variable. 3. **Item Shopping**&nbsp;&nbsp;- Create a loop to iterate through the list of identified items.&nbsp;&nbsp;- For each item, use the Perplexity Pro building block to search and generate shopping options.&nbsp;&nbsp;- Store each result in an array. 4. **Data Formatting**&nbsp;&nbsp;- Use a JavaScript building block to combine all shopping results into a single HTML table.&nbsp;&nbsp;- Format the table with columns for Item Name, Product Name, Price, and Link. 5. **Google Sheets Integration**&nbsp;&nbsp;- Use ZeroWork's Google Sheets action to create a new sheet or append to an existing one[2][3].&nbsp;&nbsp;- Write the HTML table data directly to the sheet. ## Additional Considerations - Use ZeroWork's anti-bot detection features to ensure smooth operation when interacting with Perplexity Pro[6].- Implement error handling to manage potential issues with image analysis or shopping searches.- Consider adding a delay between Perplexity Pro searches to avoid rate limiting.- Use ZeroWork's scheduling feature to run this automation at regular intervals if needed[6]. This automation leverages ZeroWork's capabilities to create a seamless workflow from image input to data output in Google Sheets, utilizing AI for image analysis and shopping recommendations. Citations:[1] https://www.descript.com/blog/article/chatgpt-image-input-how-to[2] https://www.pabbly.com/connect/integrations/zerowork-io/google-sheets/[3] https://app.zerowork.io/integrations[4] https://learn.microsoft.com/en-us/ai-builder/object-detection-model-in-flow[5] https://www.testingcatalog.com/perplexity-looks-to-challenge-amazon-with-integrated-pro-shopping-option/[6] https://www.youtube.com/watch?v=zOvAkkxG-Ps Here is a keystoke-level summary: Certainly! I'll provide a detailed, keystroke-level outline of the TaskBot, including specific configurations and code snippets where necessary. This outline assumes that ZeroWork doesn't have a native way to combine multiple HTML tables, which is why we're using JavaScript. If ZeroWork does have such a feature, that would be preferable to using custom code. ## Detailed TaskBot Configuration 1. **File Input**&nbsp;&nbsp;- Name: "HotelRoomImage"&nbsp;&nbsp;- Type: File&nbsp;&nbsp;- Allowed file types: .jpg, .png, .jpeg&nbsp;&nbsp;- Description: "Upload an image of a hotel room" 2. **ChatGPT 4 Block**&nbsp;&nbsp;- Name: "IdentifyItems"&nbsp;&nbsp;- Model: GPT-4 Vision&nbsp;&nbsp;- System Message: "You are an AI trained to identify furniture and decor items in hotel room images. List all items you can see, separated by commas."&nbsp;&nbsp;- User Message: "Identify all furniture and decor items in this image. Provide the list as comma-separated values."&nbsp;&nbsp;- Image: ${HotelRoomImage}&nbsp;&nbsp;- Output Variable: identifiedItems 3. **JavaScript Block**&nbsp;&nbsp;- Name: "SplitItemsList"&nbsp;&nbsp;- Code:&nbsp;&nbsp;&nbsp;```javascript&nbsp;&nbsp;&nbsp;const itemsList = ZeroWork.getVariable('identifiedItems').split(',').map(item =&gt; item.trim());&nbsp;&nbsp;&nbsp;ZeroWork.setVariable('itemsArray', itemsList);&nbsp;&nbsp;&nbsp;``` 4. **Loop Block**&nbsp;&nbsp;- Name: "ShoppingLoop"&nbsp;&nbsp;- Loop through: ${itemsArray}&nbsp;&nbsp;- Loop variable: currentItem &nbsp;&nbsp;4a. **Perplexity Pro Block** (inside loop)&nbsp;&nbsp;- Name: "ShopForItem"&nbsp;&nbsp;- Query: "Search for ${currentItem} and provide 3 shopping options. Format the results as an HTML table with columns for Product Name, Price, and Link."&nbsp;&nbsp;- Output Variable: itemShoppingResults &nbsp;&nbsp;4b. **JavaScript Block** (inside loop)&nbsp;&nbsp;- Name: "StoreResults"&nbsp;&nbsp;- Code:&nbsp;&nbsp;&nbsp;```javascript&nbsp;&nbsp;&nbsp;let allResults = ZeroWork.getVariable('allShoppingResults') || [];&nbsp;&nbsp;&nbsp;allResults.push({&nbsp;&nbsp;&nbsp;&nbsp;item: ZeroWork.getVariable('currentItem'),&nbsp;&nbsp;&nbsp;&nbsp;results: ZeroWork.getVariable('itemShoppingResults')&nbsp;&nbsp;&nbsp;});&nbsp;&nbsp;&nbsp;ZeroWork.setVariable('allShoppingResults', allResults);&nbsp;&nbsp;&nbsp;``` 5. **JavaScript Block**&nbsp;&nbsp;- Name: "CombineResults"&nbsp;&nbsp;- Code:&nbsp;&nbsp;&nbsp;```javascript&nbsp;&nbsp;&nbsp;const allResults = ZeroWork.getVariable('allShoppingResults');&nbsp;&nbsp;&nbsp;let combinedTable = '&lt;table&gt;&lt;tr&gt;&lt;th&gt;Item&lt;/th&gt;&lt;th&gt;Product Name&lt;/th&gt;&lt;th&gt;Price&lt;/th&gt;&lt;th&gt;Link&lt;/th&gt;&lt;/tr&gt;';&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;allResults.forEach(result =&gt; {&nbsp;&nbsp;&nbsp;&nbsp;const itemName = result.item;&nbsp;&nbsp;&nbsp;&nbsp;const itemTable = result.results;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Extract rows from the item's table&nbsp;&nbsp;&nbsp;&nbsp;const rows = itemTable.match(/&lt;tr&gt;.*?&lt;\/tr&gt;/gs).slice(1); // Skip header row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rows.forEach(row =&gt; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;combinedTable += `&lt;tr&gt;&lt;td&gt;${itemName}&lt;/td&gt;${row.slice(4, -5)}&lt;/tr&gt;`; // Remove &lt;tr&gt; and &lt;/tr&gt;&nbsp;&nbsp;&nbsp;&nbsp;});&nbsp;&nbsp;&nbsp;});&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;combinedTable += '&lt;/table&gt;';&nbsp;&nbsp;&nbsp;ZeroWork.setVariable('finalShoppingTable', combinedTable);&nbsp;&nbsp;&nbsp;``` 6. **Google Sheets Action**&nbsp;&nbsp;- Name: "SaveToSheets"&nbsp;&nbsp;- Action: Create new sheet&nbsp;&nbsp;- Spreadsheet: [Select or create a new spreadsheet]&nbsp;&nbsp;- Sheet Name: "Hotel Room Items - ${ZeroWork.formatDate(new Date(), 'YYYY-MM-DD')}"&nbsp;&nbsp;- Content: ${finalShoppingTable} ## Additional Configuration 1. **Error Handling**&nbsp;&nbsp;- Add error handling blocks after each major step (ChatGPT, Perplexity Pro, Google Sheets) to manage potential failures. 2. **Rate Limiting**&nbsp;&nbsp;- Add a "Wait" block of 2 seconds between each iteration of the shopping loop to avoid overwhelming Perplexity Pro. 3. **Anti-Bot Detection**&nbsp;&nbsp;- Enable ZeroWork's built-in anti-bot detection features for web interactions. 4. **Scheduling**&nbsp;&nbsp;- Set up a schedule for the TaskBot to run daily or weekly, depending on your needs. This detailed configuration provides a keystroke-level outline of how to set up the TaskBot in ZeroWork. The JavaScript code is necessary to process and combine the results from multiple Perplexity Pro searches into a single, coherent HTML table that can be easily saved to Google Sheets. If ZeroWork offers a native way to combine HTML tables or manipulate structured data without coding, that would be preferable. Always check the platform's latest features and documentation, as no-code solutions often introduce new capabilities that can simplify complex workflows. Last step...deliver the working script to my Zerowork account.

Desperate for Human Beings Not Lazy or a Moron

About the Client

Useful links

Company

Information

Content Writers

Freelancers

Freelance Jobs

Online Jobs

Designers

Developers

Translations