In Automation; creating test scripts involves basically two step:

1. Creating Test Data for all test cases.

2. Writing scripts for automating the test cases.

The first steps, is the outcome of analysis of what all data is required for all of your testcases to be executed. These all should be collected and scripts to be written so that TEST DATA is ready.

The second steps, is basically the test case execution steps automation.