{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/5d40715e27994cf1962fab36b4eaacf7\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/5d40715e27994cf1962fab36b4eaacf7-1678968004310.gif","duration":165.19,"title":"Use ImportRange to extract sales data for calculating in new sheet","description":"ImportRange helps you import data from one Google Sheet into another and keeps the two spreadsheets in sync at all times. This function can be useful when you only need a subset of the data in the main spreadsheet for your sales metrics and when you want to run calculations on your metrics, but don't want to edit the source spreadsheet."}