function sendConfirmationEmail(e) { const recipientEmail = e.values[1]; // Column B: Email const fullName = e.values[2]; // Column C: Full Legal Name // Email to volunteer const subject = 'Bat Cave Disaster Relief Volunteer Form Submission Confirmation'; const body = `Hi ${fullName},\n\nThanks for reaching out to Bat Cave Disaster Relief. We got your submission and someone will be in touch soon.\n\nSincerely,\nThe Bat Cave Relief Team`; MailApp.sendEmail({ to: recipientEmail, subject: subject, body: body, name: 'Bat Cave Disaster Relief', replyTo: 'batcavedisasterrelief@gmail.com' }); // Internal notification to Bat Cave team MailApp.sendEmail({ to: 'batcavedisasterrelief@gmail.com', subject: 'New Volunteer Submission', body: `You have a new volunteer submission from ${fullName}.` }); } function setTrigger() { const sheet = SpreadsheetApp.getActiveSpreadsheet(); ScriptApp.newTrigger('sendConfirmationEmail') .forSpreadsheet(sheet) .onFormSubmit() .create(); }
top of page
Bat Cave Disaster Relief volunteers in Bat Cave North Carolina

Volunteer With Us!

Bat Cave Disaster Relief volunteers in Bat Cave North Carolina

Hub Volunteers

Hub volunteers help with general maintenance of the hub, loading and unloading deliveries and assisting locals with supply needs.

Bat Cave Disaster Relief volunteers in Bat Cave North Carolina

Cooks

FREE LUNCH WEDNESDAY!!

​

Signs of progress!!

 Due to the decrease in need, we've scaled back free meals to Wednesday's at 12pm. ​

 Our BAT CAVE DOOR DASHERS come and help us prepare lunch for the community and deliver free lunch to all road workers and volunteers in Bat Cave and surrounding communities. 

​ Thank you to everyone who continues to support, serve, and strengthen our community. Together, we’re making progress!

Bat Cave Disaster Relief volunteers in Bat Cave North Carolina

Field Crews/

Trades 

Do you have experience in the trades? Or want to assist in general field work?

Bat Cave Disaster Relief volunteers in Bat Cave North Carolina

Operators

Are you qualified to operate heavy machinery?

Bat Cave Supply Hub

93 Lake Lure Hwy, Bat Cave, NC 28710

bottom of page