As for the Google grid to display a string from another site online?

Example: I need to be the domain of these website https://readmanga.me/rashititel_grobnic Display a row from a table (1-49) and a separate date of publication.
Example table:
5e994048be86a923919292.png
Is it possible ?
April 19th 20 at 12:28
1 answer
April 19th 20 at 12:30
Solution
Use IMPORTXML

If the link to the page in cell B1 the text "to read" available on the formula

=INDEX(IMPORTXML(B1;"//h4/a");1;1)

Release year

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


5e996e5426a7a942384854.png

The examples in the Table https://docs.google.com/spreadsheets/d/1MSw2YDCN2C...
Thank you very much. - Shanie.Eichmann63 commented on April 19th 20 at 12:33

Find more questions by tags Data transferGoogle SheetsHTML