Clientes Online - WhatsAppInstall

Overview

This node operation fetches and formats data from a CSV or TSV file available via a URL. It downloads the file, parses its content according to the selected delimiter (comma for CSV or tab for TSV), and processes the data based on a chosen layout format. This is useful when you need to import structured contact or customer data into your workflow, normalize it, or prepare it for further processing such as enrichment, filtering, or integration with other systems.

Practical examples include:

• Importing phone numbers only from a CSV file to send SMS campaigns.
• Processing detailed customer information including CPF (Brazilian individual taxpayer registry), names, company, and reference values for CRM updates.
• Handling geographic or contact details like name, region, address, phone, WhatsApp, latitude, and longitude for location-based services.
• Combining phone numbers with CPF or CNPJ (Brazilian company registry) for compliance or verification workflows.

Properties

Output

The node outputs JSON data representing the parsed and formatted contents of the CSV/TSV file according to the selected layout. Each item in the output corresponds to a row in the file, with fields mapped based on the chosen format. For example, if "Apenas Telefone" is selected, each output item will contain a phone number field; if a more complex layout is selected, multiple fields like CPF, name, company, etc., will be present.

No binary data output is indicated by the source code.

Dependencies

• Requires access to the internet or network location where the CSV/TSV file is hosted.
• No explicit external API keys or credentials are needed specifically for this operation beyond the general node credential setup.
• The node depends on internal helper functions (from bundled dependencies) to perform HTTP requests and CSV/TSV parsing.

Troubleshooting

• Common issues:

  • Invalid or inaccessible URL: Ensure the URL points directly to a downloadable CSV or TSV file and is reachable from the n8n environment.
  • Incorrect delimiter selection: Choosing CSV when the file is TSV (or vice versa) may cause parsing errors or incorrect data extraction.
  • Mismatched layout: Selecting a layout that does not match the actual data columns can lead to missing or misaligned fields in the output.

• Error messages:

  • Network errors when fetching the file usually indicate connectivity or URL problems.
  • Parsing errors may occur if the file content is malformed or does not conform to the expected delimiter.

• Resolutions:

  • Verify the URL and test accessibility outside n8n.
  • Confirm the file format and select the correct delimiter option.
  • Match the layout option to the actual structure of the CSV/TSV file.

Links and References

• CSV Format Specification
• TSV Format Explanation
• n8n Documentation on Working with Files
• General best practices for importing CSV data in automation workflows