Build Your First Automation on UiPath Studio Web in Under 30 Minutes
Tired of manually transferring data between spreadsheets and web forms? This step-by-step UiPath tutorial shows how to automate the entire process, from reading Google Sheets to filling web forms and saving results - all without writing code. Perfect for beginners looking to implement their first RPA solution.
What You'll Build
Manual data entry between spreadsheets and web forms is one of the most time-consuming yet common business tasks. In this tutorial, you'll create an automation that reads names and birth months from a Google Sheet, enters them into a web form at rpsamples.com/unicorn-name, generates unique unicorn names, and saves the results back to your spreadsheet.
The complete workflow demonstrates core RPA concepts you'll use in more complex automations: reading structured data, interacting with web applications, handling dynamic elements, and writing results back to source systems.
Business impact: What takes 15-30 minutes of manual work can be reduced to under 2 minutes with this automation, with zero errors. Scale this across hundreds of records and the time savings become substantial.
Prerequisites
Before starting, ensure you have these three components ready:
- A UiPath Cloud account with access to Studio Web (free tier available)
- A Google account with Drive access to create the sample spreadsheet
- The sample web form open in your browser (rpsamples.com/unicorn-name)
At the 2:15 mark in the video tutorial, you'll see how to set up the Google Sheet with the required columns: Name, Birthday Month, and Unicorn Name Value. The automation will populate the third column automatically.
Setting Up Google APIs
Unlike desktop automation, cloud-based workflows require explicit API permissions to interact with services like Google Sheets. At 4:30 in the video, the tutorial shows how to enable two critical APIs:
1. Google Sheets API - Allows UiPath to read and write spreadsheet data
2. Google Drive API - Provides access to the files containing your sheets
These permissions are enabled through the Google Cloud Console (console.cloud.google.com). The process involves:
- Searching for each API in the library
- Clicking "Enable"
- Waiting for confirmation (typically under 60 seconds)
Remember: You can disable these APIs after completing the tutorial if you're concerned about ongoing access. The automation will prompt you to re-enable them when needed.
Creating Your First Workflow
With prerequisites ready, start building at 7:15 in the video:
- Log in to UiPath Automation Cloud
- Launch Studio Web from the products menu
- Create new → RPA workflow (not API or document processing)
- Name your solution (e.g., "Generate Unicorn Name")
The workflow begins with a manual trigger by default, meaning you'll click "Run" to execute it. At 8:45, the tutorial briefly shows how to switch to scheduled execution if you want the automation to run at specific times without manual initiation.
Reading Spreadsheet Data
The core of the automation begins at 10:20 with the "For Each Row in Spreadsheet" activity. This powerful component:
- Connects to your Google Sheet using the enabled APIs
- Loops through each row of data
- Makes the current row's data available to subsequent activities
Key configuration points shown at 11:30:
- Select your Google account when prompted
- Browse to and select your specific spreadsheet file
- Choose the correct sheet (usually "Sheet1")
The tutorial includes helpful debugging at 13:45 using "Write Line" to verify data is being read correctly before proceeding with the web automation portion.
Interacting With Web Forms
At 16:20, the workflow adds browser interaction:
- Use Application/Browser - Attaches to your open unicorn name web form
- Type Into - Enters the name from the current spreadsheet row
- Select Item - Chooses the birth month from dropdown (dynamic value)
- Click - Presses the "Get Name" button to generate the unicorn name
The video at 18:10 demonstrates UiPath's powerful target indication system, where you visually select each web element (name field, month dropdown, button) to teach the automation where to interact.
Pro Tip: UiPath automatically generates reliable selectors for web elements, but you can manually adjust them if a website changes its structure slightly.
Writing Results Back
The final automation piece at 21:40 captures the generated unicorn name and writes it back to the spreadsheet:
- Get Text - Copies the unicorn name from the web page
- Write Cell - Pastes it into the correct spreadsheet cell
The tutorial explains a critical concept at 23:15: dynamic cell addressing. Rather than hardcoding cell references like "C2", the automation uses:
currentRow.unicorn_name_address - Automatically tracks which cell to write to next
This ensures the automation works regardless of how many rows your spreadsheet contains.
Testing Your Automation
At 25:30, the tutorial runs the complete workflow using "Debug on Cloud". This validation step confirms:
- All names and months are read correctly
- Web form interactions succeed for each record
- Generated names are saved to the proper spreadsheet cells
The video shows how to monitor execution and troubleshoot any issues. Common fixes include:
- Verifying Google API permissions are still active
- Re-indicating web elements if the page layout changed
- Checking for spreadsheet sharing permissions
Successful execution demonstrates how RPA can eliminate hours of manual data transfer work with a reliable, repeatable automation.
Watch the Full Tutorial
For visual learners, the complete 29-minute walkthrough demonstrates every step from blank slate to working automation. Pay special attention at 11:45 where the tutorial shows how to test spreadsheet connectivity before building the full workflow.
Key Takeaways
This beginner-friendly tutorial covers foundational RPA concepts that apply to nearly all automation projects:
In summary: UiPath Studio Web makes automation accessible without coding. By connecting systems like Google Sheets with web applications, you can eliminate repetitive data transfer tasks. The skills learned here - reading data, web interaction, and writing results - form the basis of more complex automations.
Frequently Asked Questions
Common questions about this topic
UiPath Studio Web is a cloud-based automation development environment that lets you build robotic process automation (RPA) workflows without installing software. It's particularly useful for automating repetitive tasks between web applications and spreadsheets.
The platform provides visual tools to create automations that would normally require manual data entry or complex integrations. This makes it ideal for business users without programming experience who need to streamline repetitive computer tasks.
- Browser-based - access from any computer with no installation
- Pre-built activities for common applications like Google Workspace
- Visual workflow designer instead of code
No, UiPath is designed as a low-code platform where you can build automations using visual workflows. The tutorial demonstrates how to create a complete automation without writing any code.
The platform uses a drag-and-drop interface with pre-built "activities" for common tasks like reading spreadsheets, typing into web forms, and clicking buttons. Advanced users can extend functionality with code, but most business automations don't require it.
- Visual workflow designer requires no coding
- Pre-built activities handle most common tasks
- Documentation and tutorials available for beginners
UiPath needs permission to access your Google Sheets data through official APIs. Enabling Google Sheets API and Google Drive API creates the secure connection needed for the automation to read and write spreadsheet data.
These APIs provide a standardized way for applications like UiPath to interact with Google services without compromising security. The permissions are temporary and can be revoked after completing the automation if desired.
- Required for secure access to Google Sheets data
- Permissions can be revoked after automation completes
- Only needs to be set up once per Google account
UiPath uses computer vision and selector technology to identify elements on web pages. When you indicate targets during development, UiPath records the visual and technical characteristics of each field.
The system creates multiple identification methods for each element, making the automation resilient to minor layout changes. During execution, it uses these stored references to locate and interact with the correct fields.
- Computer vision identifies field locations
- Multiple fallback selectors increase reliability
- Elements can be re-trained if websites change significantly
Yes, the tutorial briefly shows how to change from manual trigger to scheduled execution. UiPath Studio Web supports scheduling automations to run at specific times without manual intervention.
You can configure workflows to run daily, weekly, or at custom intervals. This is ideal for recurring data processing tasks like daily reports or regular data synchronization between systems.
- Supports daily/weekly/custom schedules
- Can trigger based on other events
- Runs unattended once configured
UiPath includes features to make automations resilient to minor layout changes. The system stores multiple identification methods for each element, so if one fails (like a changed CSS class), it can fall back to others.
For major changes, you would need to update the target elements in your workflow. The platform provides tools to quickly retrain elements when websites evolve, minimizing maintenance effort.
- Multiple fallback selectors for each element
- Visual retraining tools for major changes
- Change detection features alert you to potential issues
Yes, the tutorial specifically uses Google Sheets activities, but equivalent Microsoft 365 activities exist for Excel files. The workflow structure remains similar - you would just swap the Google Sheets activities for Excel activities.
You would authenticate with your Microsoft account instead of Google, and use Excel-specific activities like "For Each Row in Workbook" rather than "For Each Row in Spreadsheet." The web interaction portion would remain identical.
- Same concepts apply to Excel files
- Different activities for Microsoft 365 integration
- Requires Microsoft account authentication
GrowwStacks helps businesses implement automation workflows, AI integrations, and scalable systems tailored to their operations. Whether you need a custom workflow, AI automation, or a full multi-platform automation system, our team can design, build, and deploy a solution that fits your exact requirements.
We specialize in taking manual processes like the one demonstrated in this tutorial and transforming them into reliable, time-saving automations. Our free consultations help identify the highest-impact opportunities in your specific business context.
- Custom automation workflows built for your business
- Integration with your existing tools and platforms
- Free consultation to discuss your automation goals
Ready to Automate Your Business Processes?
Manual data entry wastes hours every week and introduces errors. Our UiPath experts can build custom automations that work with your specific systems and workflows.