Wordpress post without pre-saved connection

Hi there!
My user case is that I can store the wordpress login somewhere in google sheet and then when user pass the google sheet id > System read the row for login details and based on that specific login set it post to the wordpress

Is there a way I can do this right now it looks like I have to store all connections but I want user to have flexibility to decide which wordpress blog to save and not all time possible for me to pre-save or ask logins myself rather I want to use google sheet or form to share the logins to push the wordpress blog post to…