Auto-visit links from an existing Google Sheet or data table in ZeroWork

Introduction

In this tutorial, we will learn how to create a taskboard in ZeroWork that automates the process of visiting profile links stored in an existing Google Sheet or data table. This guide will walk you through the steps required to set up your taskboard effectively, allowing you to extract valuable information from each profile with ease.

Step 1: Create a New TaskBot

• Open ZeroWork and sign in to your account.
• Click on the option to create a new taskboard.
• Name your taskboard appropriately for easy identification.

Step 2: Add Existing Data Table

• Choose the option to add an existing data table instead of creating a new one.
• If you have previously saved profile links in a data table, select that table.
• Ensure your data table includes columns for Name, Profile Link, First Name, and Last Name.

Step 3: Set Up the Loop for Data Iteration

• Select “Dynamic” as the loop type to iterate over the rows in your data table.
• Specify the data table you are using (e.g., "profiles").
• This step ensures that the taskboard will process each row of data sequentially.

Step 4: Open Profile Links

• Add the building block for opening links.
• Reference the column containing the profile links in your data table.
• To prevent errors, consider adding a delay after opening each link.

Step 5: Save Job Title Information

• Add the building block to save the job title.
• Use the “Copy CSS Selector” plugin to obtain the CSS selector for the job title element.
• Save the extracted job title to the appropriate column in your data table.

Step 6: Check for "See More" Button

• Implement logic to check for the presence of a "See More" button on the profile.
• Use a text-based condition to identify the button.
• If the button exists, include a step to click it. If not, the taskboard will skip this action.

Step 7: Save the About Me Section

• Add another building block to save the About Me description.
• Again, use the “Copy CSS Selector” plugin to get the CSS selector for the About Me section.
• Store this information in the corresponding column in your data table.

Step 8: Handle Missing Data Gracefully

• Before saving the About Me section, add a check to ensure that the section exists.
• If the About Me section is absent, ensure the taskboard does not attempt to save an empty value.

Step 9: Set a Limit for Repetitions

• Set a repetition limit for the taskboard to visit a specified number of profiles (e.g., 3).
• This helps in testing without taking too much time during setup.

Step 10: Review Taskboard Results

• After running the taskboard, check the saved information in your data table.
• Verify that the job titles and About Me sections have been captured correctly.
• If any errors occur, consult the error report for details on what went wrong.

Conclusion

You have successfully created a taskboard that automates the visiting of profile links from a Google Sheet or data table in ZeroWork. By following these steps, you can efficiently gather job titles and About Me information, even handling situations where data might be missing. For further enhancements, consider exploring additional features in ZeroWork or integrating with other data sources.