Sometimes, the output of the =IMPORTFROMWEB() formula is an error message, usually introduced by a #. This section categorizes the different types of errors you may encounter.
General Errors
These include errors such as #ACTIVATE, #NAME, or #GOOGLE_QUOTA_EXCEEDED. Most of these issues can be resolved by activating the add-on properly, but you can find all the details about these errors on the following ressource.
Data Source Errors
Data Source Errors – such as #PAGE_REQUEST_FAILED, #PAGE_NOT_FOUND, #PAGE_IS_EMPTY, or #URL_NOT_FILLED occur when there is an issue with loading or interpreting the requested webpage. The good news is that when these errors happen, no request is counted, and most can be resolved by adjusting your input, checking the URL, or enabling the jsRendering option. You can find all the details about these errors on the following link.
Selector Errors
These include errors such as #SELECTOR_RETURNS_NULL or #SELECTOR_NOT_VALID. Most of these issues can be resolved by checking the accuracy of your selectors, using the jsRendering option, or consulting available resources on writing valid XPaths and CSS selectors. You can find all the details about these errors on the following link.
Quota Errors
Quota Errors occur when you’ve reached the limits of your current plan, whether you have a trial or a paid plan. These include #DAILY_QUOTA_REACHED, #MONTHLY_QUOTA_REACHED, #TOTAL_QUOTA_REACHED, and #END_OF_PERIOD_REACHED. You can find all the details about these errors on the following link.
Other Errors
Here is a complete list of all “Other Errors” related to regular expressions (regex) that you may encounter while using ImportFromWeb. These include #REGEX_RETURNS_NULL, #ALL_REGEXES_RETURN_NULL, and #REGEX_NOT_VALID, which typically occur when the regex pattern is incorrect or doesn’t match any data. You can find all the details about these errors on the following link.