A system and computer-implemented method for automating end-to end testing is provided. The system comprises a connection settings module to receive information for connecting with one or more external systems. The system further comprises a test setup module to create test workflows, wherein creating the test workflows comprise selecting one or more pre-stored source files and corresponding one or more pre-stored target files and mapping input and output of each of the one or more selected pre-stored source files with the corresponding one or more selected pre-stored target files for testing additional source files associated with the one or more external systems. Furthermore, the system comprises a workflow execution module to connect with the one or more external systems using the received information to retrieve the additional source files and execute the created test workflows corresponding to the retrieved one or more additional source files.