Automate Directory Scraping to Google Sheets using Browseract (Placeholder)

This n8n workflow provides a foundational structure for automating data extraction and storage, though the specific scraping logic is not yet defined within this JSON. It sets up the necessary components to manually trigger a process, execute custom code (presumably for scraping), and then store the results in Google Sheets.

What it does

This workflow, in its current state, outlines the following steps:

1. Manual Trigger: The workflow is initiated manually by clicking the 'Execute workflow' button in n8n.
2. Code Execution: A 'Code' node is present, indicating that custom JavaScript logic is intended to be run at this stage. This is where the core scraping logic using a tool like Browseract would be implemented.
3. Google Sheets Integration: A 'Google Sheets' node is configured, ready to receive and write data. This would typically be used to store the results obtained from the scraping process.

Prerequisites/Requirements

• n8n Instance: An active n8n instance to host and run the workflow.
• Google Account: A Google account with access to Google Sheets to store the scraped data.
• Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth2 recommended).
• Browseract (or similar library): While not directly visible in the JSON, the workflow's directory name suggests the use of Browseract. If this is the case, your n8n environment might need specific setup to execute Browseract-related code (e.g., via a custom Docker image or a code node that shells out).

Setup/Usage

1. Import the Workflow:
   • In your n8n instance, go to "Workflows".
   • Click "New" -> "Import from JSON" and paste the provided JSON.
2. Configure Credentials:
   • Locate the "Google Sheets" node.
   • Click on the "Credential" field and select an existing Google Sheets OAuth2 credential or create a new one. Follow the n8n documentation for setting up Google Sheets credentials if needed.
3. Implement Scraping Logic:
   • Open the "Code" node.
   • Replace the placeholder code with your actual JavaScript logic for scraping the desired directory (e.g., yp.com) using Browseract or another suitable library. This code should output the scraped data in a format consumable by the Google Sheets node.
4. Configure Google Sheets Node:
   • Select the "Google Sheets" node.
   • Specify the "Spreadsheet ID" and "Sheet Name" where you want to store the data.
   • Configure the "Operation" (e.g., "Append Row") and map the data fields from the "Code" node's output to the Google Sheet columns.
5. Test and Activate:
   • Click "Execute Workflow" to test the entire flow.
   • Once satisfied with the results, activate the workflow.