akira02/MELONBOOKS_FORMULA.md

## MELONBOOKS_FORMULA.md

      
    Raw
  

              MELONBOOKS_FORMULA.md
            
          
    Get Melonbooks page infos with Google Sheets Named function

These Google Sheets functions can help you get infos from Melonbooks website.

Get cover image of melonbooks:

Argument placeholders: url
=IMAGE(CONCAT("https:",IMPORTXML(IF(RIGHT(url,12)="adult_view=1", url, CONCAT(url,"&adult_view=1")),"(//figure[1]//img/@src)[1]")),1)
Get title of melonbooks:

Argument placeholders: url
=IMPORTXML(IF(RIGHT(url,12)="adult_view=1", url, CONCAT(url,"&adult_view=1")),"//h1")
Get price of melonbooks(number):

Argument placeholders: url
=VALUE(SUBSTITUTE(importxml(IF(RIGHT(url,12)="adult_view=1", url, CONCAT(url,"&adult_view=1")),"//span[contains(@class,'yen')]"),"¥",""))