"Ancora Imparo" - I'm still learning (Michelangelo at 87)

QA Bite ::: Use Data to Drive your Tests

I often have the issue that I need to check the same website with different input values. Last time I wanted to check if different product categories in a web shop are displayed properly in the shopping cart. The solution is to use a Google Spreadsheet which contains the different products.

  1. Create a Google Spreadsheet and enter the data you need.
  2. Share the sheet with a link such that everybody with a link is a viewer.

In you shop test, insert the action NAVIGATE_URL and Paste the link of the Google Sheet into this action and play:

  • Use arrow keys on your keyboard to navigate to the first item of the sheet
  • Use <copy> from <Control> group to copy the data to the clipboard
  • Use NAVIGATE_NEXT_TAB to get back to your shop
  • Paste data into the shop
  • Add steps to verify the Shop is ok.

Share on

About the Autor

Andreas Grau

Andreas Grau

Andreas is one of the founders of Testup. With background in Mathematical Finance, Computer Science and Engineering and many years of practical experience of business administration, he enables interdisciplinary solutions of hard practical problems.

Do you like our Bites?

We have a lot more where that came from!
Join the subscribers who stay ahead of the pack.

Want to make your life easier?

Use Testup,  the easiest test automation tool on the web. Don’t hesitate and 

Free Webinar

Uncover the secrets of automated testing in the free webinar.

Revolutionize Your Testing Process with AI-Powered Automation.

Test our
AI-Promt Feature for FREE