Create Bot to automate banking tasks with python
I would like to create a bot with python to automate some banking tasks. The bot should be able to do the following.
Log into an online banking website (e.g. Chase, CapitalOne, etc.) and download/save recent transaction activity which is given as a CSV file.
Compare contents of CSV file with a Google Sheets doc.
Based on results of previous comparison, make edits to the Google Sheets doc and the CSV file.
Transfer the updated CSV file to a remote location.
How should I go about doing this?
python automation
asked Nov 26 '18 at 2:38
KashyapKashyap
111
add a comment |
I would like to create a bot with python to automate some banking tasks. The bot should be able to do the following.
Log into an online banking website (e.g. Chase, CapitalOne, etc.) and download/save recent transaction activity which is given as a CSV file.
Compare contents of CSV file with a Google Sheets doc.
Based on results of previous comparison, make edits to the Google Sheets doc and the CSV file.
Transfer the updated CSV file to a remote location.
How should I go about doing this?
python automation
asked Nov 26 '18 at 2:38
KashyapKashyap
111
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00
add a comment |
I would like to create a bot with python to automate some banking tasks. The bot should be able to do the following.
Log into an online banking website (e.g. Chase, CapitalOne, etc.) and download/save recent transaction activity which is given as a CSV file.
Compare contents of CSV file with a Google Sheets doc.
Based on results of previous comparison, make edits to the Google Sheets doc and the CSV file.
Transfer the updated CSV file to a remote location.
How should I go about doing this?
python automation
asked Nov 26 '18 at 2:38
KashyapKashyap
111
I would like to create a bot with python to automate some banking tasks. The bot should be able to do the following.
Log into an online banking website (e.g. Chase, CapitalOne, etc.) and download/save recent transaction activity which is given as a CSV file.
Compare contents of CSV file with a Google Sheets doc.
Based on results of previous comparison, make edits to the Google Sheets doc and the CSV file.
Transfer the updated CSV file to a remote location.
How should I go about doing this?
python automation
python automation
asked Nov 26 '18 at 2:38
KashyapKashyap
111
asked Nov 26 '18 at 2:38
KashyapKashyap
111
asked Nov 26 '18 at 2:38
KashyapKashyap
111
asked Nov 26 '18 at 2:38
KashyapKashyap
111
asked Nov 26 '18 at 2:38
KashyapKashyap
111
111
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00
add a comment |
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00
add a comment |
1 Answer
1
active
oldest
votes
Welcome to StackOverflow! It is encouraged for you to post what code you have came up with so far so we can help you with specific problems. This is a very general question.
I will do my best to point you in the right direction while using Google Chrome:
First, you will want to use inspect element and look over the network logs while performing certain tasks on the website along with also taking notes of your cookies.
By doing this, your goal should be finding out how you can access your recent transactions using requests and cookies. This will likely be difficult as you are dealing with a banks website and it is likely very secure.
After figuring this out, you will want to look into the requests library as well as the Sheets API for Python. Use the requests library to log into the bank and gather the transactions. Use the sheets API to handle everything required in Google Sheets.
Another option which would be a lot easier would be using Selenium along with a headless browser: https://selenium-python.readthedocs.io/
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53474104%2fcreate-bot-to-automate-banking-tasks-with-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Welcome to StackOverflow! It is encouraged for you to post what code you have came up with so far so we can help you with specific problems. This is a very general question.
I will do my best to point you in the right direction while using Google Chrome:
First, you will want to use inspect element and look over the network logs while performing certain tasks on the website along with also taking notes of your cookies.
By doing this, your goal should be finding out how you can access your recent transactions using requests and cookies. This will likely be difficult as you are dealing with a banks website and it is likely very secure.
After figuring this out, you will want to look into the requests library as well as the Sheets API for Python. Use the requests library to log into the bank and gather the transactions. Use the sheets API to handle everything required in Google Sheets.
Another option which would be a lot easier would be using Selenium along with a headless browser: https://selenium-python.readthedocs.io/
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
add a comment |
Welcome to StackOverflow! It is encouraged for you to post what code you have came up with so far so we can help you with specific problems. This is a very general question.
I will do my best to point you in the right direction while using Google Chrome:
First, you will want to use inspect element and look over the network logs while performing certain tasks on the website along with also taking notes of your cookies.
By doing this, your goal should be finding out how you can access your recent transactions using requests and cookies. This will likely be difficult as you are dealing with a banks website and it is likely very secure.
After figuring this out, you will want to look into the requests library as well as the Sheets API for Python. Use the requests library to log into the bank and gather the transactions. Use the sheets API to handle everything required in Google Sheets.
Another option which would be a lot easier would be using Selenium along with a headless browser: https://selenium-python.readthedocs.io/
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
add a comment |
Welcome to StackOverflow! It is encouraged for you to post what code you have came up with so far so we can help you with specific problems. This is a very general question.
I will do my best to point you in the right direction while using Google Chrome:
First, you will want to use inspect element and look over the network logs while performing certain tasks on the website along with also taking notes of your cookies.
By doing this, your goal should be finding out how you can access your recent transactions using requests and cookies. This will likely be difficult as you are dealing with a banks website and it is likely very secure.
After figuring this out, you will want to look into the requests library as well as the Sheets API for Python. Use the requests library to log into the bank and gather the transactions. Use the sheets API to handle everything required in Google Sheets.
Another option which would be a lot easier would be using Selenium along with a headless browser: https://selenium-python.readthedocs.io/
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
Welcome to StackOverflow! It is encouraged for you to post what code you have came up with so far so we can help you with specific problems. This is a very general question.
I will do my best to point you in the right direction while using Google Chrome:
First, you will want to use inspect element and look over the network logs while performing certain tasks on the website along with also taking notes of your cookies.
By doing this, your goal should be finding out how you can access your recent transactions using requests and cookies. This will likely be difficult as you are dealing with a banks website and it is likely very secure.
After figuring this out, you will want to look into the requests library as well as the Sheets API for Python. Use the requests library to log into the bank and gather the transactions. Use the sheets API to handle everything required in Google Sheets.
Another option which would be a lot easier would be using Selenium along with a headless browser: https://selenium-python.readthedocs.io/
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
answered Nov 26 '18 at 3:03
Swift GeekSwift Geek
148111
148111
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53474104%2fcreate-bot-to-automate-banking-tasks-with-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Show what you have done now. StackOverflow is not a code writing service provider.
– Geno Chen
Nov 26 '18 at 2:59
Your bank definitely will not like it if you do this
– n8sty
Nov 26 '18 at 3:00