Welcome to the Cyara Knowledge Center

Use test data in your test case without having to upload your csv file to Cyara by directly calling the data from Google Sheets.  If it's only the data that changes, then simply change the data in the Google Sheet as changes are saved automatically and you test case will pick up the new changes.

Here's how you can  quickly data drive your test case using Dynamic Data and Google Sheets by following the steps below.

1. Create your test case with the key data you want to data drive
2. Create your google sheet
3. Publish to web
4. Select comma-separated values
5. Copy the link to use in your test case
6. Paste the link under Dynamic Data Service
7. Click on Preview to see the content
8. Run your test case
9. Updating the sheet will automatically update the test case data

Here are the screenshots for each step

1. Create your test case with the key data you want to data drive. 

2. Create your google sheet

3. Publish to web

4. Select comma-separated values

5. Copy the link to use in your test case

6. Paste the link under Dynamic Data Service

7. Click on Preview to see the content

8. Run your test case

9. Updating the sheet will automatically update the test case data