I have had this happen once to me, by surprise.
A little background; I’m Jewish by upbringing but agnostic by nature. Way back when in high school, as a gag, I sent my postcard to the Universal Life Church and got a certificate making me an Official Minister of the ULC. Says that I can perform weddings, funerals and other such ceremonies.
About 15 years later two of my very good friends decided to get married and asked me to officiate at their wedding (they knew about the ULC thing). I checked the laws and in SF county it’s completely cool, so we went ahead with the planning.
OK, so then we have the rehearsal dinner. The two extended families are in, we are all meeting & greeting and having a good time. Groom’s family puts on a big dinner at a restaurant.
We sit down to eat and suddenly the groom’s Mom says “Reverend, will you lead us in grace?” 50 pairs of eyes are on me.
Gulp. Think “Deer caught in the headlights”. Right then, the bride’s sister (only other person who happened to know what variety of ministerial credentials I hold), who was sitting next to me, whispered very quietly “Wing it, Rev!”.
Which is what I did - I’ve had dinner with families who say grace before so we all joined hands, bowed our heads, and I said something like “Dear Lord, we thank you for the presence of our friends and family and for the food that we are about to receive. Amen.” Came off pretty well I think. Bride and Groom thought this was hilarious afterwards.
The point here is that I knew that the families didn’t know I wasn’t a religious fellow and I was being asked to perform a small but important duty, and that this is intended as a compliment to the person being asked to say grace, not a way to put them on the spot or something.
Given this I think that it would have been awfully rude for me to decline, and I was able to improvise a perfectly acceptable grace and avoid anyone being embarassed (family members or myself). I certainly didn’t feel like it changed my spiritual outlook or betrayed my beliefs or anything - this was simply being courteous and respectful towards them and the occasion.
The right response would vary a bit depending on the circumstances, but I can’t see why the previously mentioned “We are thankful for the blahdeeblahdeeblah…” wouldn’t be fine just about anywhere, regardless of your personal beliefs.
If you really don’t want to say grace for whatever reason I think that the best response would be to say “I’m sorry, I don’t know how, could Joe do the honors?” You can tell the person your reason later. If they were to intentionally try and put you on the spot after that, I’d give the same excuse and then rethink any invites I got from those people.
I don’t think that a snappy comeback or a flat “No” is OK though, it’s taking offense when none was meant and it’s rude - sort of like giving a clerk a lecture on religious sensitivity if they say “Merry Christmas” when you buy something in December.
And the wedding went off without a hitch. Wonderful ceremony on a yacht in the SF bay