ansible network automation

i need help with ansible script.
I am working on a project for network automation. The task include.
1. connect to network device
2. collect output of a command
3. from the output, fecth only mac address and serial number of all devices
4. copy the collected mac addr and serial number in a csv file
5. the csv file should take name of the device
6. import the csv file to cloud device
7. add all the mac addr and serial number in csv to cloud device