Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to import all the links from a webpage using IMPORTXML.
Google Sheets
=IMPORTXML("https://example.com", "[1]")
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using XPath that selects elements but not their attributes.
Confusing image sources with links.
✗ Incorrect
The XPath //a/@href selects all link URLs from anchor tags on the page.
2fill in blank
mediumComplete the formula to import all the titles inside <title> tags from a webpage.
Google Sheets
=IMPORTXML("https://example.com", "[1]")
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using XPath that assumes is inside <body> or <div>.</div><div class="mistake-item">Including extra path steps that are unnecessary.</div></div></div><div class="feedback-box incorrect d-none"><div class="feedback-title">✗ Incorrect</div><div class="feedback-text"><p>The XPath <code>//title</code> selects all <title> tags anywhere in the document.</p></div></div></div></div><div class="puzzle-container " id="puzzle-fill_in_blank-2"><div class="task-card " id="try-t3" data-blank-count="1"><div class="task-header"><div class="task-badge"><span class="task-number">3</span><span class="task-type">fill in blank</span></div><span class="task-difficulty hard">hard</span></div><p class="task-instruction text-pre-wrap ">Fix the error in the formula to import all paragraph texts from a webpage.</p><div class="code-block"><div class="code-header"><span class="code-title">Google Sheets</span></div><pre class="code-content" id="code-t3">=IMPORTXML(<span class="hl-str">"https://example.com"</span>, <span class="code-blank" data-blank="1" data-task="t3">[1]</span>)</pre></div><div class="blank-selection-hint" id="hint-select-t3"><span class="d-flex align-items-center justify-content-center flex-wrap gap-1 line-height-normal"><span class="new-material-symbols icon-hw-22"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 -960 960 960" fill="#EF4444"><path d="M480-240q-76.33 0-138.83-43.5-62.5-43.5-87.5-115.83-4-12 2-23.34 6-11.33 19-15.33 13-4.33 25.83 2.17 12.83 6.5 18.83 20.83 19.67 49 63.34 78.67 43.66 29.66 97.33 29.66 72 0 122.67-50.66Q653.33-408 653.33-480q0-53-29.83-96.83-29.83-43.84-78.83-63.5-14.67-6-20.67-18.84-6-12.83-1.67-25.83 4.34-13 15.5-19 11.17-6 23.17-2 71 25 115 87.17 44 62.16 44 138.83 0 100-70 170t-170 70Zm0 160q-161.33 0-277.33-110.67-116-110.66-123-271.33-.34-13.33 8.83-23t22.83-10.67q13.67-1 24.5 8.84 10.84 9.83 12.17 24.5 12.67 138 106.17 226.83 93.5 88.83 225.83 88.83 139.33 0 236.33-97t97-236.33q0-133.67-90-228.17T496.67-812q-14.67-1.33-23.84-11.67-9.16-10.33-8.83-24.66.33-13.67 10-22.67 9.67-9 23-8.67 80 3 149.83 36 69.84 33 121.5 87.17Q820-702.33 850-631.17 880-560 880-480q0 83-31.5 156T763-197q-54 54-127 85.5T480-80Zm-97.33-420-132-131-33.34 101Q213-518 201-518.5q-12-.5-15.67-12.5L89.67-850q-2.67-9.33 4.5-16.5 7.16-7.17 16.5-4.5l319 95.67q12 3.66 12.5 15.66t-11.5 16.34l-101 33.33 132 132q17 17 17 39t-17 39q-17 17-39.5 17t-39.5-17Z"></path></svg></span> Drag options to blanks, or click blank then click option'</span></div><div class="fill-options" id="fillOptions-t3"><div class="fill-option " draggable="true" data-key="A" data-task="t3"><span class="option-key">A</span>"//p/text()"</div><div class="fill-option " draggable="true" data-key="B" data-task="t3"><span class="option-key">B</span>"//p"</div><div class="fill-option " draggable="true" data-key="C" data-task="t3"><span class="option-key">C</span>"//text()"</div><div class="fill-option " draggable="true" data-key="D" data-task="t3"><span class="option-key">D</span>"p/text()"</div></div><button class="verify-btn" id="verifyBtn-t3" disabled=""><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M5 13l4 4L19 7"></path></svg>Verify Answer</button><div class="attempts-counter" id="attempts-t3"><span>Attempts:</span><div class="attempts-dots"><span class="attempt-dot "></span><span class="attempt-dot "></span><span class="attempt-dot "></span></div><span id="attemptsLeft-t3">3<!-- --> left</span></div><div class="hint-box d-none" id="hint-t3"><div class="hint-box-title">💡 Hint</div><div class="hint-box-text" id="hintText-t3"></div></div><div class="mistakes-box d-none" id="mistakes-t3"><div class="mistakes-box-title">Common Mistakes</div><div class="mistakes-list"><div class="mistake-item">Using XPath that selects the whole element instead of text nodes.</div><div class="mistake-item">Omitting quotes around the XPath string.</div></div></div><div class="feedback-box incorrect d-none"><div class="feedback-title">✗ Incorrect</div><div class="feedback-text"><p>The XPath <code>//p/text()</code> selects the text nodes inside all paragraph tags, which IMPORTXML can import as text.</p></div></div></div></div><div class="puzzle-container " id="puzzle-fill_in_blank-3"><div class="task-card " id="try-t4" data-blank-count="2"><div class="task-header"><div class="task-badge"><span class="task-number">4</span><span class="task-type">fill in blank</span></div><span class="task-difficulty hard">hard</span></div><p class="task-instruction text-pre-wrap ">Fill both blanks to import all image URLs and all link URLs from a webpage.</p><div class="code-block"><div class="code-header"><span class="code-title">Google Sheets</span></div><pre class="code-content" id="code-t4">=IMPORTXML(<span class="hl-str">"https://example.com"</span>, <span class="hl-str">"</span><span class="code-blank" data-blank="1" data-task="t4">[1]</span> | <span class="code-blank" data-blank="2" data-task="t4">[2]</span><span class="hl-str">")</span></pre></div><div class="blank-selection-hint" id="hint-select-t4"><span class="d-flex align-items-center justify-content-center flex-wrap gap-1 line-height-normal"><span class="new-material-symbols icon-hw-22"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 -960 960 960" fill="#EF4444"><path d="M480-240q-76.33 0-138.83-43.5-62.5-43.5-87.5-115.83-4-12 2-23.34 6-11.33 19-15.33 13-4.33 25.83 2.17 12.83 6.5 18.83 20.83 19.67 49 63.34 78.67 43.66 29.66 97.33 29.66 72 0 122.67-50.66Q653.33-408 653.33-480q0-53-29.83-96.83-29.83-43.84-78.83-63.5-14.67-6-20.67-18.84-6-12.83-1.67-25.83 4.34-13 15.5-19 11.17-6 23.17-2 71 25 115 87.17 44 62.16 44 138.83 0 100-70 170t-170 70Zm0 160q-161.33 0-277.33-110.67-116-110.66-123-271.33-.34-13.33 8.83-23t22.83-10.67q13.67-1 24.5 8.84 10.84 9.83 12.17 24.5 12.67 138 106.17 226.83 93.5 88.83 225.83 88.83 139.33 0 236.33-97t97-236.33q0-133.67-90-228.17T496.67-812q-14.67-1.33-23.84-11.67-9.16-10.33-8.83-24.66.33-13.67 10-22.67 9.67-9 23-8.67 80 3 149.83 36 69.84 33 121.5 87.17Q820-702.33 850-631.17 880-560 880-480q0 83-31.5 156T763-197q-54 54-127 85.5T480-80Zm-97.33-420-132-131-33.34 101Q213-518 201-518.5q-12-.5-15.67-12.5L89.67-850q-2.67-9.33 4.5-16.5 7.16-7.17 16.5-4.5l319 95.67q12 3.66 12.5 15.66t-11.5 16.34l-101 33.33 132 132q17 17 17 39t-17 39q-17 17-39.5 17t-39.5-17Z"></path></svg></span> Drag options to blanks, or click blank then click option'</span></div><div class="fill-options" id="fillOptions-t4"><div class="fill-option " draggable="true" data-key="A" data-task="t4"><span class="option-key">A</span>//img/@src</div><div class="fill-option " draggable="true" data-key="B" data-task="t4"><span class="option-key">B</span>//a/@href</div><div class="fill-option " draggable="true" data-key="C" data-task="t4"><span class="option-key">C</span>//div</div><div class="fill-option " draggable="true" data-key="D" data-task="t4"><span class="option-key">D</span>//span</div></div><button class="verify-btn" id="verifyBtn-t4" disabled=""><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M5 13l4 4L19 7"></path></svg>Verify Answer</button><div class="attempts-counter" id="attempts-t4"><span>Attempts:</span><div class="attempts-dots"><span class="attempt-dot "></span><span class="attempt-dot "></span><span class="attempt-dot "></span></div><span id="attemptsLeft-t4">3<!-- --> left</span></div><div class="hint-box d-none" id="hint-t4"><div class="hint-box-title">💡 Hint</div><div class="hint-box-text" id="hintText-t4"></div></div><div class="mistakes-box d-none" id="mistakes-t4"><div class="mistakes-box-title">Common Mistakes</div><div class="mistakes-list"><div class="mistake-item">Using element selectors instead of attribute selectors.</div><div class="mistake-item">Not combining the two XPath expressions correctly.</div></div></div><div class="feedback-box incorrect d-none"><div class="feedback-title">✗ Incorrect</div><div class="feedback-text"><p>The XPath <code>//img/@src</code> selects all image URLs, and <code>//a/@href</code> selects all link URLs. Using the pipe <code>|</code> combines both selections.</p></div></div></div></div><div class="puzzle-container " id="puzzle-fill_in_blank-4"><div class="task-card " id="try-t5" data-blank-count="3"><div class="task-header"><div class="task-badge"><span class="task-number">5</span><span class="task-type">fill in blank</span></div><span class="task-difficulty hard">hard</span></div><p class="task-instruction text-pre-wrap ">Fill all three blanks to import all product names, prices, and availability from a webpage with structured HTML.</p><div class="code-block"><div class="code-header"><span class="code-title">Google Sheets</span></div><pre class="code-content" id="code-t5">=IMPORTXML(<span class="hl-str">"https://example.com/products"</span>, <span class="hl-str">"//div[@class='product']/</span><span class="code-blank" data-blank="1" data-task="t5">[1]</span> | //div[@<span class="hl-kw">class</span>=<span class="hl-str">'product'</span>]/<span class="code-blank" data-blank="2" data-task="t5">[2]</span> | //div[@<span class="hl-kw">class</span>=<span class="hl-str">'product'</span>]/<span class="code-blank" data-blank="3" data-task="t5">[3]</span><span class="hl-str">")</span></pre></div><div class="blank-selection-hint" id="hint-select-t5"><span class="d-flex align-items-center justify-content-center flex-wrap gap-1 line-height-normal"><span class="new-material-symbols icon-hw-22"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 -960 960 960" fill="#EF4444"><path d="M480-240q-76.33 0-138.83-43.5-62.5-43.5-87.5-115.83-4-12 2-23.34 6-11.33 19-15.33 13-4.33 25.83 2.17 12.83 6.5 18.83 20.83 19.67 49 63.34 78.67 43.66 29.66 97.33 29.66 72 0 122.67-50.66Q653.33-408 653.33-480q0-53-29.83-96.83-29.83-43.84-78.83-63.5-14.67-6-20.67-18.84-6-12.83-1.67-25.83 4.34-13 15.5-19 11.17-6 23.17-2 71 25 115 87.17 44 62.16 44 138.83 0 100-70 170t-170 70Zm0 160q-161.33 0-277.33-110.67-116-110.66-123-271.33-.34-13.33 8.83-23t22.83-10.67q13.67-1 24.5 8.84 10.84 9.83 12.17 24.5 12.67 138 106.17 226.83 93.5 88.83 225.83 88.83 139.33 0 236.33-97t97-236.33q0-133.67-90-228.17T496.67-812q-14.67-1.33-23.84-11.67-9.16-10.33-8.83-24.66.33-13.67 10-22.67 9.67-9 23-8.67 80 3 149.83 36 69.84 33 121.5 87.17Q820-702.33 850-631.17 880-560 880-480q0 83-31.5 156T763-197q-54 54-127 85.5T480-80Zm-97.33-420-132-131-33.34 101Q213-518 201-518.5q-12-.5-15.67-12.5L89.67-850q-2.67-9.33 4.5-16.5 7.16-7.17 16.5-4.5l319 95.67q12 3.66 12.5 15.66t-11.5 16.34l-101 33.33 132 132q17 17 17 39t-17 39q-17 17-39.5 17t-39.5-17Z"></path></svg></span> Drag options to blanks, or click blank then click option'</span></div><div class="fill-options" id="fillOptions-t5"><div class="fill-option " draggable="true" data-key="A" data-task="t5"><span class="option-key">A</span>span[@class='name']</div><div class="fill-option " draggable="true" data-key="B" data-task="t5"><span class="option-key">B</span>span[@class='price']</div><div class="fill-option " draggable="true" data-key="C" data-task="t5"><span class="option-key">C</span>span[@class='availability']</div><div class="fill-option " draggable="true" data-key="D" data-task="t5"><span class="option-key">D</span>div[@class='description']</div></div><button class="verify-btn" id="verifyBtn-t5" disabled=""><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M5 13l4 4L19 7"></path></svg>Verify Answer</button><div class="attempts-counter" id="attempts-t5"><span>Attempts:</span><div class="attempts-dots"><span class="attempt-dot "></span><span class="attempt-dot "></span><span class="attempt-dot "></span></div><span id="attemptsLeft-t5">3<!-- --> left</span></div><div class="hint-box d-none" id="hint-t5"><div class="hint-box-title">💡 Hint</div><div class="hint-box-text" id="hintText-t5"></div></div><div class="mistakes-box d-none" id="mistakes-t5"><div class="mistakes-box-title">Common Mistakes</div><div class="mistakes-list"><div class="mistake-item">Selecting wrong class names or elements.</div><div class="mistake-item">Not combining the XPath queries properly.</div></div></div><div class="feedback-box incorrect d-none"><div class="feedback-title">✗ Incorrect</div><div class="feedback-text"><p>Each XPath selects a specific span inside the product div: name, price, and availability. Combining them with <code>|</code> imports all three data types.</p></div></div></div></div></div></div></article></div></div></main><div style="position:fixed;bottom:24px;right:24px;z-index:50"><button style="background:rgba(255,255,255,0.95);border:1px solid rgba(108,99,255,0.18);border-radius:10px;padding:10px 16px;color:#5f56fe;font-size:14px;cursor:pointer;display:flex;align-items:center;gap:7px;backdrop-filter:blur(12px);box-shadow:0 2px 12px rgba(0,0,0,0.08), 0 0 0 1px rgba(108,99,255,0.06);transition:all 0.2s"><span style="font-size:14px">⚑</span>Report Issue</button></div></div> <script src="/_next/static/chunks/webpack-fd24bd8e19d2841a.js" async=""></script><script>(self.__next_f=self.__next_f||[]).push([0]);self.__next_f.push([2,null])</script><script>self.__next_f.push([1,"1:HL[\"/_next/static/css/b133bdac07c7940e.css\",\"style\"]\n2:HL[\"/_next/static/css/837a603cb1a59856.css\",\"style\"]\n3:HL[\"/_next/static/css/725c7861d1898ba8.css\",\"style\"]\n4:HL[\"/_next/static/css/caf3ca742c7945f9.css\",\"style\"]\n"])</script><script>self.__next_f.push([1,"5:I[95751,[],\"\"]\n8:I[39275,[],\"\"]\ne:I[61343,[],\"\"]\nf:I[84080,[\"8726\",\"static/chunks/8726-583188341cbc1496.js\",\"3185\",\"static/chunks/app/layout-7a1373330f6a4c98.js\"],\"\"]\n10:I[88726,[\"8726\",\"static/chunks/8726-583188341cbc1496.js\",\"3185\",\"static/chunks/app/layout-7a1373330f6a4c98.js\"],\"Toaster\"]\n11:I[20154,[\"8422\",\"static/chunks/66ec4792-a0fc378024be0c7b.js\",\"6648\",\"static/chunks/6648-fff0cf0e0a1f8d25.js\",\"9160\",\"static/chunks/app/not-found-c4181ddc3e64e5f3.js\"],\"default\"]\n12:I[70548,[\"8726\",\"static/chunks/8726-583188341cbc1496.js\",\"3185\",\"static/chunks/app/layout-7a1373330f6a4c98.js\"],\"default\"]\n14:I[76130,[],\"\"]\n9:[\"lang\",\"en\",\"d\"]\na:[\"subject\",\"google-sheets\",\"d\"]\nb:[\"part\",\"part-3\",\"d\"]\nc:[\"pattern\",\"google-sheets-importxml-for-structured-data\",\"d\"]\nd:[\"mode\",\"try\",\"oc\"]\n15:[]\n"])</script><script>self.__next_f.push([1,"0:[[[\"$\",\"link\",\"0\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/b133bdac07c7940e.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}]],[\"$\",\"$L5\",null,{\"buildId\":\"hN8t5By7h5nzsrdSose07\",\"assetPrefix\":\"\",\"initialCanonicalUrl\":\"/en/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\",\"initialTree\":[\"\",{\"children\":[[\"lang\",\"en\",\"d\"],{\"children\":[\"codefly\",{\"children\":[\"learn\",{\"children\":[[\"subject\",\"google-sheets\",\"d\"],{\"children\":[[\"part\",\"part-3\",\"d\"],{\"children\":[[\"pattern\",\"google-sheets-importxml-for-structured-data\",\"d\"],{\"children\":[[\"mode\",\"try\",\"oc\"],{\"children\":[\"__PAGE__\",{}]}]}]}]}]}]}]}]},\"$undefined\",\"$undefined\",true],\"initialSeedData\":[\"\",{\"children\":[[\"lang\",\"en\",\"d\"],{\"children\":[\"codefly\",{\"children\":[\"learn\",{\"children\":[[\"subject\",\"google-sheets\",\"d\"],{\"children\":[[\"part\",\"part-3\",\"d\"],{\"children\":[[\"pattern\",\"google-sheets-importxml-for-structured-data\",\"d\"],{\"children\":[[\"mode\",\"try\",\"oc\"],{\"children\":[\"__PAGE__\",{},[[\"$L6\",\"$L7\"],null],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\",\"learn\",\"children\",\"$a\",\"children\",\"$b\",\"children\",\"$c\",\"children\",\"$d\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":[[\"$\",\"link\",\"0\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/837a603cb1a59856.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}],[\"$\",\"link\",\"1\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/725c7861d1898ba8.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}],[\"$\",\"link\",\"2\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/caf3ca742c7945f9.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}]]}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\",\"learn\",\"children\",\"$a\",\"children\",\"$b\",\"children\",\"$c\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\",\"learn\",\"children\",\"$a\",\"children\",\"$b\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\",\"learn\",\"children\",\"$a\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\",\"learn\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\",\"codefly\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\",\"$9\",\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":\"$undefined\",\"notFoundStyles\":\"$undefined\",\"styles\":null}],null]},[[\"$\",\"html\",null,{\"lang\":\"en\",\"children\":[[\"$\",\"head\",null,{\"children\":[[\"$\",\"meta\",null,{\"name\":\"theme-color\",\"content\":\"#5f56fe\"}],[\"$\",\"meta\",null,{\"name\":\"msapplication-TileColor\",\"content\":\"#5f56fe\"}],[\"$\",\"$Lf\",null,{\"src\":\"https://www.googletagmanager.com/gtag/js?id=G-N2NY2DMMDW\",\"strategy\":\"afterInteractive\"}],[\"$\",\"$Lf\",null,{\"id\":\"google-analytics\",\"strategy\":\"afterInteractive\",\"children\":\"\\n window.dataLayer = window.dataLayer || [];\\n function gtag(){dataLayer.push(arguments);}\\n gtag('js', new Date());\\n gtag('config', 'G-N2NY2DMMDW', {\\n page_path: window.location.pathname,\\n });\\n \"}],[\"$\",\"script\",null,{\"async\":true,\"src\":\"https://www.googletagmanager.com/gtag/js?id=AW-17928224938\"}],[\"$\",\"$Lf\",null,{\"children\":\"\\n window.dataLayer = window.dataLayer || [];\\n function gtag() {\\n dataLayer.push(arguments);\\n }\\n gtag('js', new Date());\\n gtag('config', 'AW-17928224938');\\n \"}],[\"$\",\"script\",null,{\"data-grow-initializer\":\"\",\"suppressHydrationWarning\":true,\"dangerouslySetInnerHTML\":{\"__html\":\"!(function(){window.growMe||((window.growMe=function(e){window.growMe._.push(e);}),(window.growMe._=[]));var e=document.createElement(\\\"script\\\");(e.type=\\\"text/javascript\\\"),(e.src=\\\"https://faves.grow.me/main.js\\\"),(e.defer=!0),e.setAttribute(\\\"data-grow-faves-site-id\\\",\\\"U2l0ZTo0MGIxZDBlZC0wNzdlLTQ0NjgtOThmOC1kNDYyZGMwM2IwMWY=\\\");var t=document.getElementsByTagName(\\\"script\\\")[0];t.parentNode.insertBefore(e,t);})();\"}}],[\"$\",\"$Lf\",null,{\"src\":\"//scripts.scriptwrapper.com/tags/40b1d0ed-077e-4468-98f8-d462dc03b01f.js\",\"strategy\":\"afterInteractive\",\"data-noptimize\":\"1\",\"data-cfasync\":\"false\"}],[\"$\",\"script\",null,{\"type\":\"application/ld+json\",\"suppressHydrationWarning\":true,\"dangerouslySetInnerHTML\":{\"__html\":\"{\\\"@context\\\":\\\"https://schema.org\\\",\\\"@type\\\":\\\"WebApplication\\\",\\\"name\\\":\\\"Leyaa.ai\\\",\\\"description\\\":\\\"Leyaa.ai builds learning intelligence that understands how you learn - guiding what to study, how to practice, and when to move forward.\\\",\\\"url\\\":\\\"https://leyaa.ai\\\",\\\"applicationCategory\\\":\\\"EducationalApplication\\\",\\\"operatingSystem\\\":\\\"Web\\\",\\\"offers\\\":{\\\"@type\\\":\\\"Offer\\\",\\\"price\\\":\\\"0\\\",\\\"priceCurrency\\\":\\\"USD\\\"},\\\"creator\\\":{\\\"@type\\\":\\\"Organization\\\",\\\"name\\\":\\\"Leyaa.ai\\\"}}\"}}],[\"$\",\"link\",null,{\"href\":\"https://cdn.jsdelivr.net/npm/bootstrap@5.3.8/dist/css/bootstrap.min.css\",\"rel\":\"stylesheet\",\"integrity\":\"sha384-sRIl4kxILFvY47J16cr9ZwB07vP4J8+LH7qKQnuqkuIAvNWLzeN8tE5YBujZqJLB\",\"crossOrigin\":\"anonymous\"}],[\"$\",\"$Lf\",null,{\"id\":\"clarity-script\",\"strategy\":\"afterInteractive\",\"dangerouslySetInnerHTML\":{\"__html\":\"\\n (function(c,l,a,r,i,t,y){\\n c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)};\\n t=l.createElement(r);t.async=1;t.src=\\\"https://www.clarity.ms/tag/\\\"+i;\\n y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y);\\n })(window, document, \\\"clarity\\\", \\\"script\\\", \\\"w4gxh6rdmh\\\");\\n \"}}]]}],[\"$\",\"body\",null,{\"children\":[[\"$\",\"$L10\",null,{\"containerStyle\":{\"top\":70}}],[\"$\",\"div\",null,{\"className\":\"bg-grid\"}],[\"$\",\"$L8\",null,{\"parallelRouterKey\":\"children\",\"segmentPath\":[\"children\"],\"error\":\"$undefined\",\"errorStyles\":\"$undefined\",\"errorScripts\":\"$undefined\",\"template\":[\"$\",\"$Le\",null,{}],\"templateStyles\":\"$undefined\",\"templateScripts\":\"$undefined\",\"notFound\":[\"$\",\"$L11\",null,{}],\"notFoundStyles\":[[\"$\",\"link\",\"0\",{\"rel\":\"stylesheet\",\"href\":\"/_next/static/css/250d3fff07338fa3.css\",\"precedence\":\"next\",\"crossOrigin\":\"$undefined\"}]],\"styles\":null}],[\"$\",\"$L12\",null,{}],\" \"]}]]}],null],null],\"couldBeIntercepted\":false,\"initialHead\":[false,\"$L13\"],\"globalErrorComponent\":\"$14\",\"missingSlots\":\"$W15\"}]]\n"])</script><script>self.__next_f.push([1,"17:I[51766,[\"8422\",\"static/chunks/66ec4792-a0fc378024be0c7b.js\",\"522\",\"static/chunks/94730671-fd9628eddbd5107b.js\",\"7240\",\"static/chunks/53c13509-506edbde2b5b3f55.js\",\"7699\",\"static/chunks/8e1d74a4-a085c2fbc868135a.js\",\"5706\",\"static/chunks/9c4e2130-11ecd4bfc78e4568.js\",\"1779\",\"static/chunks/0e762574-6b3bda54d2fd2e14.js\",\"6648\",\"static/chunks/6648-fff0cf0e0a1f8d25.js\",\"3463\",\"static/chunks/3463-09ee572e3d7819a2.js\",\"4889\",\"static/chunks/4889-956a916919971629.js\",\"9985\",\"static/chunks/9985-b39235669d2563e2.js\",\"7627\",\"static/chunks/7627-224bb765a4decf1d.js\",\"7652\",\"static/chunks/7652-412e201fe52797ee.js\",\"8935\",\"static/chunks/8935-c1c159349bf7da40.js\",\"9663\",\"static/chunks/9663-fdcd080af3916e3e.js\",\"7029\",\"static/chunks/app/%5Blang%5D/codefly/learn/%5Bsubject%5D/%5Bpart%5D/%5Bpattern%5D/%5B%5B...mode%5D%5D/page-1fc9c577a9450e06.js\"],\"default\"]\n16:T504,{\"@context\":\"https://schema.org\",\"@type\":\"LearningResource\",\"name\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice\",\"description\":\"Practice IMPORTXML for structured data in Google Sheets with interactive drag-and-drop exercises. Complete code by filling in the blanks. Instant feedback, hints \u0026 explanations. Free.\",\"url\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\",\"learningResourceType\":\"Practice Exercise\",\"programmingLanguage\":\"Google Sheets\",\"inLanguage\":\"en\",\"isAccessibleForFree\":true,\"teaches\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice\",\"provider\":{\"@type\":\"Organization\",\"url\":\"https://leyaa.ai\"},\"educationalLevel\":\"Beginner to Advanced\",\"breadcrumb\":{\"@type\":\"BreadcrumbList\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https://leyaa.ai\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice\",\"item\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Try It\",\"item\":\"https"])</script><script>self.__next_f.push([1,"://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\"}]}}"])</script><script>self.__next_f.push([1,"7:[[[\"$\",\"script\",\"0\",{\"type\":\"application/ld+json\",\"dangerouslySetInnerHTML\":{\"__html\":\"$16\"}}]],[\"$\",\"$L17\",null,{\"subject\":\"google-sheets\",\"dbSubject\":\"google_sheets\",\"part\":\"part-3\",\"pattern\":\"google_sheets_importxml_for_structured_data\",\"modeSlug\":\"try\",\"lang\":\"en\",\"internalLinks\":[{\"code\":\"LMC\",\"slug\":\"\",\"label\":\"📖 Learn\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data\",\"active\":false},{\"code\":\"LMCWHY\",\"slug\":\"why\",\"label\":\"💡 Why Learn This\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/why\",\"active\":false},{\"code\":\"DLM\",\"slug\":\"deep\",\"label\":\"💡 Deep Learn Mode\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/deep\",\"active\":false},{\"code\":\"TMC\",\"slug\":\"try\",\"label\":\"✏️ Try It\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\",\"active\":true},{\"code\":\"VMC\",\"slug\":\"visualize\",\"label\":\"👁 Visualize\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/visualize\",\"active\":false},{\"code\":\"TCM\",\"slug\":\"complexity\",\"label\":\"⏱ Complexity\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/complexity\",\"active\":false},{\"code\":\"CMC\",\"slug\":\"challenge\",\"label\":\"🏆 Challenge\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/challenge\",\"active\":false},{\"code\":\"PMC\",\"slug\":\"project\",\"label\":\"📁 Project\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/project\",\"active\":false},{\"code\":\"RMC\",\"slug\":\"review\",\"label\":\"🧠 Quick Review\",\"href\":\"/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/review\",\"active\":false}],\"isLoggedIn\":false,\"seoH1\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice\",\"contentData\":{\"pattern_id\":\"google_sheets_importxml_for_structured_data\",\"metadata\":{\"slot_map\":{\"LMCWHY\":\"LMCWHY\",\"TMC\":\"TMC\",\"CMC\":\"CMC\",\"RMC\":\"RMC\",\"VMC\":\"SHT\",\"TCM\":\"DAS\",\"PMC\":\"SCN\",\"DLM\":\"DLM\",\"TLM\":\"TLM\"}},\"modes\":{\"TMC\":{\"topic\":\"IMPORTXML for structured data\",\"mode\":\"TMC_v5\",\"language\":\"google_sheets\",\"content_type\":\"Spreadsheet \u0026 Formulas\",\"tasks\":[{\"id\":\"t1\",\"type\":\"fill_in_blank\",\"difficulty\":\"easy\",\"instruction\":\"Complete the formula to import all the links from a webpage using IMPORTXML.\",\"code\":\"=IMPORTXML(\\\"https://example.com\\\", \\\"{{BLANK_1}}\\\")\",\"options\":{\"A\":\"\\\"//img/@src\\\"\",\"B\":\"\\\"//a/@href\\\"\",\"C\":\"\\\"//p\\\"\",\"D\":\"\\\"//div\\\"\"},\"correct_answer\":[\"B\"],\"answer_explanation\":\"\u003cp\u003eThe XPath \u003ccode\u003e//a/@href\u003c/code\u003e selects all link URLs from anchor tags on the page.\u003c/p\u003e\",\"hints\":[{\"level\":1,\"hint\":\"Look for the XPath that selects link URLs.\"},{\"level\":2,\"hint\":\"Anchor tags are \u003ccode\u003ea\u003c/code\u003e and their URLs are in the \u003ccode\u003ehref\u003c/code\u003e attribute.\"}],\"common_mistakes\":[\"Using XPath that selects elements but not their attributes.\",\"Confusing image sources with links.\"],\"max_attempts\":3,\"time_limit_seconds\":120},{\"id\":\"t2\",\"type\":\"fill_in_blank\",\"difficulty\":\"medium\",\"instruction\":\"Complete the formula to import all the titles inside \u003ctitle\u003e tags from a webpage.\",\"code\":\"=IMPORTXML(\\\"https://example.com\\\", \\\"{{BLANK_1}}\\\")\",\"options\":{\"A\":\"\\\"//div/title\\\"\",\"B\":\"\\\"//body/title\\\"\",\"C\":\"\\\"//head/title\\\"\",\"D\":\"\\\"//title\\\"\"},\"correct_answer\":[\"D\"],\"answer_explanation\":\"\u003cp\u003eThe XPath \u003ccode\u003e//title\u003c/code\u003e selects all \u003ctitle\u003e tags anywhere in the document.\u003c/p\u003e\",\"hints\":[{\"level\":1,\"hint\":\"The \u003ccode\u003etitle\u003c/code\u003e tag is usually inside the \u003ccode\u003ehead\u003c/code\u003e section.\"},{\"level\":2,\"hint\":\"Using \u003ccode\u003e//title\u003c/code\u003e selects all title tags regardless of location.\"}],\"common_mistakes\":[\"Using XPath that assumes \u003ctitle\u003e is inside \u003cbody\u003e or \u003cdiv\u003e.\",\"Including extra path steps that are unnecessary.\"],\"max_attempts\":3,\"time_limit_seconds\":120},{\"id\":\"t3\",\"type\":\"fill_in_blank\",\"difficulty\":\"hard\",\"instruction\":\"Fix the error in the formula to import all paragraph texts from a webpage.\",\"code\":\"=IMPORTXML(\\\"https://example.com\\\", {{BLANK_1}})\",\"options\":{\"A\":\"\\\"//p/text()\\\"\",\"B\":\"\\\"//p\\\"\",\"C\":\"\\\"//text()\\\"\",\"D\":\"\\\"p/text()\\\"\"},\"correct_answer\":[\"A\"],\"answer_explanation\":\"\u003cp\u003eThe XPath \u003ccode\u003e//p/text()\u003c/code\u003e selects the text nodes inside all paragraph tags, which IMPORTXML can import as text.\u003c/p\u003e\",\"hints\":[{\"level\":1,\"hint\":\"You need to select the text inside the paragraph tags.\"},{\"level\":2,\"hint\":\"Using \u003ccode\u003e/text()\u003c/code\u003e after the tag selects the text content.\"}],\"common_mistakes\":[\"Using XPath that selects the whole element instead of text nodes.\",\"Omitting quotes around the XPath string.\"],\"max_attempts\":3,\"time_limit_seconds\":120},{\"id\":\"t4\",\"type\":\"fill_in_blank\",\"difficulty\":\"hard\",\"instruction\":\"Fill both blanks to import all image URLs and all link URLs from a webpage.\",\"code\":\"=IMPORTXML(\\\"https://example.com\\\", \\\"{{BLANK_1}} | {{BLANK_2}}\\\")\",\"options\":{\"A\":\"//img/@src\",\"B\":\"//a/@href\",\"C\":\"//div\",\"D\":\"//span\"},\"correct_answer\":[\"A\",\"B\"],\"answer_explanation\":\"\u003cp\u003eThe XPath \u003ccode\u003e//img/@src\u003c/code\u003e selects all image URLs, and \u003ccode\u003e//a/@href\u003c/code\u003e selects all link URLs. Using the pipe \u003ccode\u003e|\u003c/code\u003e combines both selections.\u003c/p\u003e\",\"hints\":[{\"level\":1,\"hint\":\"One XPath should select image sources, the other link URLs.\"},{\"level\":2,\"hint\":\"Use the pipe symbol \u003ccode\u003e|\u003c/code\u003e to combine two XPath queries.\"}],\"common_mistakes\":[\"Using element selectors instead of attribute selectors.\",\"Not combining the two XPath expressions correctly.\"],\"max_attempts\":3,\"time_limit_seconds\":180},{\"id\":\"t5\",\"type\":\"fill_in_blank\",\"difficulty\":\"hard\",\"instruction\":\"Fill all three blanks to import all product names, prices, and availability from a webpage with structured HTML.\",\"code\":\"=IMPORTXML(\\\"https://example.com/products\\\", \\\"//div[@class='product']/{{BLANK_1}} | //div[@class='product']/{{BLANK_2}} | //div[@class='product']/{{BLANK_3}}\\\")\",\"options\":{\"A\":\"span[@class='name']\",\"B\":\"span[@class='price']\",\"C\":\"span[@class='availability']\",\"D\":\"div[@class='description']\"},\"correct_answer\":[\"A\",\"B\",\"C\"],\"answer_explanation\":\"\u003cp\u003eEach XPath selects a specific span inside the product div: name, price, and availability. Combining them with \u003ccode\u003e|\u003c/code\u003e imports all three data types.\u003c/p\u003e\",\"hints\":[{\"level\":1,\"hint\":\"Look for spans with class names matching the data you want.\"},{\"level\":2,\"hint\":\"Use the pipe \u003ccode\u003e|\u003c/code\u003e to combine multiple XPath queries.\"}],\"common_mistakes\":[\"Selecting wrong class names or elements.\",\"Not combining the XPath queries properly.\"],\"max_attempts\":3,\"time_limit_seconds\":180}],\"learning_checkpoint\":{\"after_task\":3,\"micro_summary\":\"You learned how to write XPath queries for IMPORTXML to extract links, titles, and text from webpages.\"},\"metadata\":{\"version\":\"5.0\",\"content_type\":\"spreadsheet\",\"total_tasks\":5,\"estimated_time_minutes\":10}}},\"subject\":\"google_sheets\",\"title\":\"IMPORTXML for structured data\"},\"syllabusData\":{\"part\":\"part-3\",\"subject\":\"google_sheets\",\"difficulty\":\"advanced\",\"metadata\":{\"total_topics\":6,\"total_patterns\":45,\"patterns_with_content\":45,\"created_at\":\"2026-03-03T13:36:38.405606Z\",\"version\":\"4.2\",\"upload_tool\":\"upload_to_mongo.py v2.0\"},\"part_title\":\"Advanced\",\"subjectTitle\":\"Google Sheets\",\"topics\":[{\"topic_id\":\"google_sheets_p3_t1\",\"title\":\"Data Import and Connection\",\"order\":1,\"pattern_count\":7,\"patterns\":[{\"pattern_id\":\"google_sheets_why_external_data_expands_analysis\",\"title\":\"Why external data expands analysis\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_importdata_for_csv_tsv\",\"title\":\"IMPORTDATA for CSV/TSV\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_importhtml_for_web_tables\",\"title\":\"IMPORTHTML for web tables\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_importxml_for_structured_data\",\"title\":\"IMPORTXML for structured data\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_importrange_for_other_spreadsheets\",\"title\":\"IMPORTRANGE for other spreadsheets\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_importfeed_for_rss\",\"title\":\"IMPORTFEED for RSS\",\"order\":6,\"has_content\":true},{\"pattern_id\":\"google_sheets_connected_sheets_bigquery\",\"title\":\"Connected Sheets (BigQuery)\",\"order\":7,\"has_content\":true}]},{\"topic_id\":\"google_sheets_p3_t2\",\"title\":\"Apps Script Basics\",\"order\":2,\"pattern_count\":8,\"patterns\":[{\"pattern_id\":\"google_sheets_why_apps_script_automates_google_sheets\",\"title\":\"Why Apps Script automates Google Sheets\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_script_editor_overview\",\"title\":\"Script editor overview\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_custom_functions\",\"title\":\"Custom functions\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_triggers_onedit_onopen\",\"title\":\"Triggers (onEdit, onOpen)\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_reading_and_writing_cell_values\",\"title\":\"Reading and writing cell values\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_creating_custom_menus\",\"title\":\"Creating custom menus\",\"order\":6,\"has_content\":true},{\"pattern_id\":\"google_sheets_sending_emails_from_sheets\",\"title\":\"Sending emails from Sheets\",\"order\":7,\"has_content\":true},{\"pattern_id\":\"google_sheets_api_calls_from_apps_script\",\"title\":\"API calls from Apps Script\",\"order\":8,\"has_content\":true}]},{\"topic_id\":\"google_sheets_p3_t3\",\"title\":\"Advanced Conditional Formatting\",\"order\":3,\"pattern_count\":6,\"patterns\":[{\"pattern_id\":\"google_sheets_why_advanced_rules_highlight_patterns\",\"title\":\"Why advanced rules highlight patterns\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_color_scales\",\"title\":\"Color scales\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_custom_formulabased_rules\",\"title\":\"Custom formula-based rules\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_datebased_formatting\",\"title\":\"Date-based formatting\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_crosscolumn_conditional_rules\",\"title\":\"Cross-column conditional rules\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_managing_rule_priority\",\"title\":\"Managing rule priority\",\"order\":6,\"has_content\":true}]},{\"topic_id\":\"google_sheets_p3_t4\",\"title\":\"Collaboration Features\",\"order\":4,\"pattern_count\":8,\"patterns\":[{\"pattern_id\":\"google_sheets_why_collaboration_is_sheets_superpower\",\"title\":\"Why collaboration is Sheets' superpower\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_realtime_coediting\",\"title\":\"Real-time co-editing\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_comments_and_suggestions\",\"title\":\"Comments and suggestions\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_edit_history_and_version_control\",\"title\":\"Edit history and version control\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_filter_views_vs_filters\",\"title\":\"Filter views vs filters\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_protected_sheets_and_ranges\",\"title\":\"Protected sheets and ranges\",\"order\":6,\"has_content\":true},{\"pattern_id\":\"google_sheets_notification_rules\",\"title\":\"Notification rules\",\"order\":7,\"has_content\":true},{\"pattern_id\":\"google_sheets_publishing_to_web\",\"title\":\"Publishing to web\",\"order\":8,\"has_content\":true}]},{\"topic_id\":\"google_sheets_p3_t5\",\"title\":\"Data Visualization Advanced\",\"order\":5,\"pattern_count\":8,\"patterns\":[{\"pattern_id\":\"google_sheets_why_advanced_charts_tell_deeper_stories\",\"title\":\"Why advanced charts tell deeper stories\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_combo_charts\",\"title\":\"Combo charts\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_sparklines_line_bar_column\",\"title\":\"Sparklines (LINE, BAR, COLUMN)\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_scatter_plots\",\"title\":\"Scatter plots\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_geo_charts_and_maps\",\"title\":\"Geo charts and maps\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_timeline_charts\",\"title\":\"Timeline charts\",\"order\":6,\"has_content\":true},{\"pattern_id\":\"google_sheets_org_charts\",\"title\":\"Org charts\",\"order\":7,\"has_content\":true},{\"pattern_id\":\"google_sheets_chart_interactivity\",\"title\":\"Chart interactivity\",\"order\":8,\"has_content\":true}]},{\"topic_id\":\"google_sheets_p3_t6\",\"title\":\"Productivity and Integration\",\"order\":6,\"pattern_count\":8,\"patterns\":[{\"pattern_id\":\"google_sheets_why_integration_multiplies_value\",\"title\":\"Why integration multiplies value\",\"order\":1,\"has_content\":true},{\"pattern_id\":\"google_sheets_linking_sheets_with_docs\",\"title\":\"Linking Sheets with Docs\",\"order\":2,\"has_content\":true},{\"pattern_id\":\"google_sheets_linking_sheets_with_slides\",\"title\":\"Linking Sheets with Slides\",\"order\":3,\"has_content\":true},{\"pattern_id\":\"google_sheets_google_forms_to_sheets\",\"title\":\"Google Forms to Sheets\",\"order\":4,\"has_content\":true},{\"pattern_id\":\"google_sheets_sheets_with_google_data_studio_looker\",\"title\":\"Sheets with Google Data Studio (Looker)\",\"order\":5,\"has_content\":true},{\"pattern_id\":\"google_sheets_addons_and_extensions\",\"title\":\"Add-ons and extensions\",\"order\":6,\"has_content\":true},{\"pattern_id\":\"google_sheets_template_gallery_usage\",\"title\":\"Template gallery usage\",\"order\":7,\"has_content\":true},{\"pattern_id\":\"google_sheets_sheets_api_basics\",\"title\":\"Sheets API basics\",\"order\":8,\"has_content\":true}]}]},\"modeCode\":\"TMC\",\"productId\":\"codefly\"}]]\n"])</script><script>self.__next_f.push([1,"13:[[\"$\",\"meta\",\"0\",{\"name\":\"viewport\",\"content\":\"width=device-width, initial-scale=1\"}],[\"$\",\"meta\",\"1\",{\"charSet\":\"utf-8\"}],[\"$\",\"title\",\"2\",{\"children\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice | Leyaa.ai\"}],[\"$\",\"meta\",\"3\",{\"name\":\"description\",\"content\":\"Practice IMPORTXML for structured data in Google Sheets with interactive drag-and-drop exercises. Complete code by filling in the blanks. Instant feedback, hints \u0026 explanations. Free.\"}],[\"$\",\"meta\",\"4\",{\"name\":\"author\",\"content\":\"Leyaa.ai\"}],[\"$\",\"link\",\"5\",{\"rel\":\"manifest\",\"href\":\"/manifest.json\",\"crossOrigin\":\"use-credentials\"}],[\"$\",\"meta\",\"6\",{\"name\":\"keywords\",\"content\":\"learning intelligence,AI learning,personalized learning,adaptive learning,study guide,exam preparation,learning platform,education technology,edtech,smart learning\"}],[\"$\",\"meta\",\"7\",{\"name\":\"creator\",\"content\":\"Leyaa.ai\"}],[\"$\",\"meta\",\"8\",{\"name\":\"publisher\",\"content\":\"Leyaa.ai\"}],[\"$\",\"meta\",\"9\",{\"name\":\"robots\",\"content\":\"index, follow\"}],[\"$\",\"meta\",\"10\",{\"name\":\"googlebot\",\"content\":\"index, follow, max-image-preview:large, max-snippet:-1\"}],[\"$\",\"meta\",\"11\",{\"name\":\"content-language\",\"content\":\"en\"}],[\"$\",\"link\",\"12\",{\"rel\":\"canonical\",\"href\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\"}],[\"$\",\"link\",\"13\",{\"rel\":\"alternate\",\"hrefLang\":\"en\",\"href\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\"}],[\"$\",\"link\",\"14\",{\"rel\":\"alternate\",\"hrefLang\":\"x-default\",\"href\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\"}],[\"$\",\"meta\",\"15\",{\"property\":\"og:title\",\"content\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice | Leyaa.ai\"}],[\"$\",\"meta\",\"16\",{\"property\":\"og:description\",\"content\":\"Practice IMPORTXML for structured data in Google Sheets with interactive drag-and-drop exercises. Complete code by filling in the blanks. Instant feedback, hints \u0026 explanations. Free.\"}],[\"$\",\"meta\",\"17\",{\"property\":\"og:url\",\"content\":\"https://leyaa.ai/codefly/learn/google-sheets/part-3/google-sheets-importxml-for-structured-data/try\"}],[\"$\",\"meta\",\"18\",{\"property\":\"og:locale\",\"content\":\"en_US\"}],[\"$\",\"meta\",\"19\",{\"property\":\"og:image\",\"content\":\"https://leyaa.ai/Assets/metaImages/leyaa-preview-image.png\"}],[\"$\",\"meta\",\"20\",{\"property\":\"og:image:width\",\"content\":\"1200\"}],[\"$\",\"meta\",\"21\",{\"property\":\"og:image:height\",\"content\":\"630\"}],[\"$\",\"meta\",\"22\",{\"property\":\"og:image:alt\",\"content\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice\"}],[\"$\",\"meta\",\"23\",{\"property\":\"og:type\",\"content\":\"article\"}],[\"$\",\"meta\",\"24\",{\"name\":\"twitter:card\",\"content\":\"summary_large_image\"}],[\"$\",\"meta\",\"25\",{\"name\":\"twitter:site\",\"content\":\"@leyaaai\"}],[\"$\",\"meta\",\"26\",{\"name\":\"twitter:creator\",\"content\":\"@leyaaai\"}],[\"$\",\"meta\",\"27\",{\"name\":\"twitter:title\",\"content\":\"IMPORTXML for structured data in Google Sheets - Interactive Code Practice | Leyaa.ai\"}],[\"$\",\"meta\",\"28\",{\"name\":\"twitter:description\",\"content\":\"Practice IMPORTXML for structured data in Google Sheets with interactive drag-and-drop exercises. Complete code by filling in the blanks. Instant feedback, hints \u0026 explanations. Free.\"}],[\"$\",\"meta\",\"29\",{\"name\":\"twitter:image\",\"content\":\"https://leyaa.ai/Assets/metaImages/leyaa-preview-image.png\"}],[\"$\",\"link\",\"30\",{\"rel\":\"icon\",\"href\":\"/leyaa-logo.png\"}],[\"$\",\"link\",\"31\",{\"rel\":\"apple-touch-icon\",\"href\":\"/leyaa-logo.png\"}],[\"$\",\"meta\",\"32\",{\"name\":\"next-size-adjust\"}]]\n"])</script><script>self.__next_f.push([1,"6:null\n"])</script></body></html>