M
M
Mr.2020-04-17 08:38:41
HTML
Mr., 2020-04-17 08:38:41

How to display a row from another site online in a Google spreadsheet?

Example: I need a row from the table (1-49) and a separate publication date to be displayed from the domain of these site https://readmanga.me/rashititel_grobnic .
Table example:
5e994048be86a923919292.png
Is it possible?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-04-17
@ALeBig

Use IMPORTXML
If the link to the page in cell B1 that the text "read" is available by the formula
=INDEX(IMPORTXML(B1;"//h4/a");1;1)
Year of issue

=INDEX(IMPORTXML(B1;"//span[@class="elem_year"]/a");1;1)

5e996e5426a7a942384854.png
Example in Spreadsheet https://docs.google.com/spreadsheets/d/1MSw2YDCN2C...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question