YEs, the last thing i tried was pasting the whole URL to see if something happens, but before that, i always had the right credentials with the right URL, if not i wouldnt be able to make the few hundreds post i made that day.
The real answer is in your second point, about the IP block, Godaddy says that theres nothing wrong with the server and they can not find any problem, but then i went and bought another hosting on the same godaddy, installed a new wordpress, and added to the old workflow. Its now working. but the server its another one, so its obvious that the few hundreds post i made was detected as an attack by the server, and blacklisted the ip, but godaddy's support agents brains could not reach that conclusion.
I know all customer services are not trash, but i always bump into the most trashy ones, and that doesnt exclude you guys, when i finally got the right answer after long days, i had already solved my problem by myself. Just a positive critic to invite you guys to be better, read your customers inquiry first, and you will know if its a novice or something more than that, treat the inquiry according to the knowledge level of the customer and the troubleshooting he already told you he has completed, and take off from there, dont just assume everybody is dumb.
To avoid future ip blacklists by servers, Pabbly could add some smart random delays between requests when they are sent all at once. Besides that, congratulations guys, your service its amazing, i wouldnt change it for any other, and i have tried all of them.
Question: Can you add a field for password in the Create Post option of wordpress integration? so i can receive the password right from sheets.