You can easily add new leads from a Google Sheet to Mailchimp using Zapier's automated workflows called Zaps. With no coding knowledge required, users can create their own Zaps or start with pre-made templates. To set up the integration, users need to connect their Google Sheets and Mailchimp accounts, select the specific spreadsheet and page to trigger the Zap, and then map data from the Google Sheet to the corresponding fields in Mailchimp. The process involves testing the trigger and action steps to ensure accurate subscriber data is saved to Mailchimp.