How can I generate a list from a Google sheet – Subject7

In order to generate a list which is available on Google sheets, follow these steps:

1. On the Google sheet, click Share

2. Click Change to anyone with the link as the sheet needs to be accessible and does not request for permission when viewed from another device.

3. Click Copy link and Done

4. Modify the last portion of the URL that was copied as shown below:

Original URL:

https://docs.google.com/spreadsheets/d/1JNA8tH90rf72SKVwZf45I7pRDquzaeCzqNucvEovUBo/edit?usp=sharing

Modified URL (you can use either CSV or XLS):

https://docs.google.com/spreadsheets/d/1JNA8tH90rf72SKVwZf45I7pRDquzaeCzqNucvEovUBo/export?format=csv

5. On Subject7 platform, create a test case with Set_List command, add a variable name and select the file extension (CSV or XLS). You can also enable "First line contains column names" if your spreadsheet contains a header so this will use the first row fields as headers.

6. Next to CSV/XLS Source Type, click URL instead of File.

7. Add the modified URL from step 4 into the URL field

8. You can now run the test case to confirm the list was created successfully. To see the contents of the list, click on the 3 dots in Variables (Watch Window) highlighted below:

9. The list will be displayed as below:

10. Any update you perform on Google sheets will be reflected after you execute this step one more time.

Comments