Import Score from myanimelist.net into google sheets
What would I need to type into google sheets to import the score "8.40" from this url (https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu)? I would also like to know how to import the people "2414" and score "5" for the 4 reviews from the same url.
html css xpath google-sheets
asked Nov 12 at 19:35
Muya
82
add a comment |
What would I need to type into google sheets to import the score "8.40" from this url (https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu)? I would also like to know how to import the people "2414" and score "5" for the 4 reviews from the same url.
html css xpath google-sheets
asked Nov 12 at 19:35
Muya
82
1
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06
add a comment |
What would I need to type into google sheets to import the score "8.40" from this url (https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu)? I would also like to know how to import the people "2414" and score "5" for the 4 reviews from the same url.
html css xpath google-sheets
asked Nov 12 at 19:35
Muya
82
What would I need to type into google sheets to import the score "8.40" from this url (https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu)? I would also like to know how to import the people "2414" and score "5" for the 4 reviews from the same url.
html css xpath google-sheets
html css xpath google-sheets
asked Nov 12 at 19:35
Muya
82
asked Nov 12 at 19:35
Muya
82
asked Nov 12 at 19:35
Muya
82
asked Nov 12 at 19:35
Muya
82
asked Nov 12 at 19:35
Muya
82
82
1
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06
add a comment |
1
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06
1
1
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06
add a comment |
1 Answer
1
active
oldest
votes
Just to get you started with what you should be contributing:
=importxml("https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu","//div[@class='fl-l score']")
answered Nov 12 at 23:08
pnuts
47.6k76195
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%2f53268950%2fimport-score-from-myanimelist-net-into-google-sheets%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
Just to get you started with what you should be contributing:
=importxml("https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu","//div[@class='fl-l score']")
answered Nov 12 at 23:08
pnuts
47.6k76195
add a comment |
Just to get you started with what you should be contributing:
=importxml("https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu","//div[@class='fl-l score']")
answered Nov 12 at 23:08
pnuts
47.6k76195
add a comment |
Just to get you started with what you should be contributing:
=importxml("https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu","//div[@class='fl-l score']")
answered Nov 12 at 23:08
pnuts
47.6k76195
Just to get you started with what you should be contributing:
=importxml("https://myanimelist.net/anime/31240/Re_Zero_kara_Hajimeru_Isekai_Seikatsu","//div[@class='fl-l score']")
answered Nov 12 at 23:08
pnuts
47.6k76195
answered Nov 12 at 23:08
pnuts
47.6k76195
answered Nov 12 at 23:08
pnuts
47.6k76195
answered Nov 12 at 23:08
pnuts
47.6k76195
47.6k76195
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53268950%2fimport-score-from-myanimelist-net-into-google-sheets%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
1
Hello, welcome to StackOverflow. Please try to find a solution for yourself and then post a more specific question. These types of "How to do X" questions are not really welcome here. To get you started though, you may want to look at unofficial myanimelist APIs that do just that, e.g. Jikan.moe api.jikan.moe/v3/anime/31240 which gives a JSON with all data jikan.moe
– elveti
Nov 12 at 22:06