First, you need to export the data you wish to transfer from Webflow. Navigate to the Webflow Editor and go to the CMS Collections. Use the export option to download the data in CSV format. This file will serve as the source for your data transfer.

Review the exported CSV file to ensure data consistency and format it to match your Redshift table schema. Clean up any unnecessary fields and ensure that the data types in the CSV match the corresponding Redshift table data types to prevent loading issues.

If you haven't already set up your Redshift environment, log into your AWS Management Console and create a new Redshift cluster. Ensure that the cluster is in a publicly accessible subnet and note down the cluster endpoint for use in later steps.

Using SQL Workbench/J or any SQL client, connect to your Redshift cluster. Create the necessary tables that reflect the structure of your Webflow data. Use the `CREATE TABLE` statement to define the table schema based on the cleaned CSV file.

Use the AWS Management Console or AWS CLI to upload your CSV file to an Amazon S3 bucket. This step is crucial as Redshift can load data directly from S3, facilitating the data transfer process.

In your SQL client connected to Redshift, use the `COPY` command to load data from the S3 bucket into your Redshift table. The syntax typically looks like:
```sql
COPY your_table_name
FROM 's3://your-bucket-name/your-file.csv'
CREDENTIALS 'aws_access_key_id=YOUR_ACCESS_KEY;aws_secret_access_key=YOUR_SECRET_KEY'
CSV;
```
Ensure you replace placeholders with your actual S3 bucket and AWS credentials.

After executing the `COPY` command, verify that all data has been correctly transferred to your Redshift table. Run queries to check row counts and sample data to ensure accuracy. Address any discrepancies by reviewing the CSV data format and re-executing the upload process if necessary.

By following these steps, you can effectively migrate data from Webflow to Amazon Redshift without relying on third-party services.